Wednesday, August 23, 2006

SQL server 2005 JDBC driver name

Microsoft uses a new JDBC driver for SQL server 2005. The driver is contained in sqlserver.jar file. The driver can be downloaded from Microsoft SQL Server 2005 JDBC Driver. The driver name and the connection url string are:

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver:



For SQL server 2003, the driver name and the connection url string are:

com.microsoft.jdbc.sqlserver.SQLServerDriver

jdbc:microsoft:sqlserver:



When using the old driver name to access SQL server 2005, the java code gets this error:

java.sql.SQLException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): The supplied value is not a valid instance of data type ...

0 Comments:

Post a Comment

<< Home