Where is the Microsoft SQL Server 2005 JDBC Driver?


Question: I installed Microsoft SQL Server, but I can't find the SQL Server JDBC Driver. Where is it located?

Answer:
Visit the Microsoft SQL Server JDBC Driver home page at https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

Click on the download link extract the files for your environment. After extracting, you can find the directory, "sqljdbc2_x.xenu", with the version you downloaded replacing the "x.x" in the foldername. You will find several .jar files in this directory. Use the one that is the same or less than your JRE version.

This jar file must be in the CLASSPATH. The easiest way to do this is to put the jar file in the %ISCOBOL%jars (or $ISCOBOL/jars) folder.

Then set the jdbc.driver and jdbc.url in your properties file. There is a list of common driver and URL settings in isCOBOL's documentation under isCOBOL Evolve/SDK User's Guide/ Programming Guides/JDBC

For instance, the common SQL Server settings would be:

   iscobol.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
   iscobol.jdbc.url=jdbc:sqlserver://192.168.1.10:1433;databaseName=mydbname
replacing 192.168.1.10 with your server hostname or IP address, and mydbname with the name of your database.

Article ID: 67
Created: September 2, 2009
Last Updated: May 17, 2022
Author: Support KB Author

Online URL: https://support.veryant.com/support/phpkb/article.php?id=67