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

1. How do I set up JDBC to communicate with Oracle database?
2. Trying to work with MS SQL I get the error "JRE (Java Runtime Environment) version 1.7 is not supported by this driver. use classlibrary sqljdbc4.jar witch supports JDBC 4.0".
3. Does Oracle Pro*COBOL work with isCOBOL?
4. Where can I get products and services for Postgres (PostgreSQL)?
5. Can isCOBOL access Oracle, MS SQL and other RDBMS?
6. How to manage a large COBOL OCCURS on a Database with Database Bridge