How do I use isCOBOL ESQL with Microsoft SQL Server?

To connect to Microsoft SQL Server use Microsoft's JDBC driver or another JDBC driver that supports Microsoft SQL Server.

  1. Install the Microsoft SQL Server JDBC Driver from http://msdn.microsoft.com/en-us/data/aa937724.aspx
    For example, install it in C:\Program Files\Microsoft SQL Server 2005 JDBC Driver

  2. Include the sqljdbc.jar file in your class path.
    For example,
    SET CLASSPATH=C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar;%CLASSPATH%

  3. Specify the JDBC driver class with the iscobol.jdbc.driver property
    For example,
    iscobol.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

  4. Set the JDBC connection URL with the iscobol.jdbc.url property
    For example,
    iscobol.jdbc.url=jdbc:sqlserver://192.168.1.10:1433;databaseName=mydbname

    Replace 192.168.1.10 with the correct IP address, 1433 with the correct port number and mydbname with the correct name for your database.
Contact Veryant Support if you would like further assistance.

Article ID: 121
Created: February 15, 2010
Last Updated: February 15, 2010
Author: Support KB Author

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