How do I use isCOBOL ESQL with Microsoft SQL Server?

Question ID : 121
Created on 2010-02-15 at 4:04 PM
Author : Veryant Support [support@veryant.com]

Online URL : http://support.veryant.com/support/phpkb/question.php?ID=121


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 FilesMicrosoft SQL Server 2005 JDBC Driver

  2. Include the sqljdbc.jar file in your class path.
    For example,
    SET CLASSPATH=C:Program FilesMicrosoft SQL Server 2005 JDBC Driversqljdbc_1.2enusqljdbc.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.

Back to Original Question