Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqljdbc4 can connect to 2005/2008 but not 2000

839990Feb 15 2011 — edited Feb 15 2011
Today I updated the sqljdbc jar file from

Microsoft SQLServer 2005 JDBC Driver/../sqljdbc.jar

to

Microsoft SQLServer JDBC Driver 3.0/../sqljdbc4.jar

in order to connect to our 2005 and 2008 SQLServers. I have no problem connecting to these servers with the new jar.

However, when I try to connect to the SQLServer 2000 server I get the following:


WARNING: ConnectionID:1 Prelogin error: host publication port 1433 Unexpected response status:0

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host publication, port 1433 has failed. Error: "The driver received an unexpected pre-login response. Verify the connection properties and check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. This driver can be used only with SQL Server 2000 or later.".

Switching back to the original sqljdbc jar file, I can again connect to SQLServer 2000 server. (but of course not to the 2008 server)

This is driving me nuts!

thanks for any insight you can provide.

diane
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2011
Added on Feb 15 2011
#connection, #java-database-connectivity-jdbc, #jdbc
1 comment
1,204 views