jdbc driver for SQL 2008
Which jdbc driver should be used for connecting SQL 2008 from a java script ?
I am using following code :
String url = "jdbc:sqlserver://server:1433;<DatabaseName>";
Its not laoding the driver itself.
its throwing error :
"The server version is not supported. The target server must be SQL Server 2000 or later."
What could be the reason for this error? plz help me.
Re: jdbc driver for SQL 2008
Have a look and check if you use the appropriate driver, it must be jdbc 2.0
you might be using jdbc 1.2, but make sure that JDBC is also compatible with JRE you use, the jdbc 2.0 is compatible with 1.5 and later !