Connection.JDBC and SQL Server 2008
Developers creating Logi applications for Java, and using Connection.JDBC to connect to Microsoft SQL Server 2008, may encounter the following errors: There was a problem running a DataLayer. The error was: Could not open the supplied connection to the data. The server version is not supported. The target server must be SQL Server 2000 or later. This occurs when a newer JDBC driver is required for SQL Server 2008. The solution is:
- Download a new driver from Microsoft and uncompress the download.
- From the download, copy the file sqljdbc4.jar to your Logi application's WEB-INF/lib folder.
- Delete the old driver, sqljdbc.jar, from the same folder.
- Restart the web server.
- Run the Logi application.
If the following error message is received: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0. it means you either did not remove the original sqljdbc.jar, replaced it with the sqljdbc.jar file that came with the download instead of adding sqljdbc4.jar to the folder, or did not restart the web server.
Please sign in to leave a comment.