Hi.
I am having trouble getting the above IDE service tab, DB connection
to a SQL 2000 DB.
I am using XP and a MS downloaded driver;
Microsoft SQL Server 2000 Driver for JDBC
I seem to get the driver register in the IDE but on connecting to a DB
it fails to connect and provides no error message. I have to cancel
the process (after a long wait).
However, I have been able to get DB connection outside of the IDE with
a simple Java application. The relevant statements I use in this
application (and also try in the IDE without success) are;
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver");
connection = DriverManager.getConnection( "jdbc:microsoft:sqlserver://
localhost:1433;DataBaseName=Shares;User=sa;Password=secret" );
This latter statement has the URL connection string I try to use.
Is there any one who can do this or indicate my issues please help?
Am I trying to use the MS driver out on context ?
Regards JC......
John B. Matthews - 22 Jun 2009 16:31 GMT
In article
<63e40b3f-afbc-48f8-853e-7e49ee59a718@j20g2000vbp.googlegroups.com>,
> I am having trouble getting the above IDE service tab, DB connection
> to a SQL 2000 DB. I am using XP and a MS downloaded driver;
[quoted text clipped - 16 lines]
> Is there any one who can do this or indicate my issues please help?
> Am I trying to use the MS driver out on context ?
I have no recent experience with MS SQL Server, but I've seen anomalies
arise from incorrectly resolving the name localhost. You might try a raw
IP address, 127.0.0.1.
Also, you might try a different connection URL syntax:
<http://msdn.microsoft.com/en-us/library/ms378428(SQL.90).aspx>

Signature
John B. Matthews
trashgod at gmail dot com
<http://sites.google.com/site/drjohnbmatthews>
Arne Vajhøj - 23 Jun 2009 01:59 GMT
> I am having trouble getting the above IDE service tab, DB connection
> to a SQL 2000 DB.
[quoted text clipped - 17 lines]
> Is there any one who can do this or indicate my issues please help?
> Am I trying to use the MS driver out on context ?
Check that SQLServer has TCP/IP enabled and that there are no firewall
blocking.
Arne