Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

The TDS prelogin response is incomplete

 
Jignesh Khambhayta
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i m trying to connect the MS SQL. I already set the class path of the mssql jar file. i m getting follwoing exception.

CODE:
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=JavaTest;","sa","");

EXCEPTION:

com.microsoft.sqlserver.jdbc.SQLServerException: The TDS prelogin response is incomplete. The target server must be SQL Server 2000 or later.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Connect.getConnection(Connect.java:12)
at Connect.displayDbProperties(Connect.java:28)
at Connect.main(Connect.java:64)
Error Trace in getConnection() : The TDS prelogin response is incomplete. The target server must be SQL Server 2000 or later.
Error: No active Connection
 
Scott Dunbar
Ranch Hand
Posts: 245
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think that this error is pretty self explanatory - you're logging into an MS/SQL server that is older than SQL Server 2000 and the driver requires at least that version.
[ April 07, 2006: Message edited by: Scott Dunbar ]
 
Maximilian Xavier Stocker
Ranch Hand
Posts: 381
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic