Hi,
I get the following error when I try to test the JDBC driver for SQL Server 2000.
Test of TN Failed
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
I have checked all values a thousand times and everything seems correct. I dont know what else to try.
Can someone help me?
Thank you very much.
Internal pools uses DataDirect driver, the connection URL must be something like:
Associated Driver Alias: DataDirect Connect JDBC SQL Server Driver
Database URL: jdbc:wm:sqlserver://localhost:1433;databaseName=myDatabase
From the error you have, looks like you have configured a native SQL server driver.
Check your connection URL and Driver alias.
How can i check connection URL and Driver alias??
The URL im using is:
jdbc:microsoft:sqlserver://localhost:1433;databaseName=TNDB;SelectMethod=cursor;SendStringParametersAsUnicode=false
