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=mydbnamereplacing 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