Title: 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 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.
Authored by: Veryant Support on Mon, Feb 15th, 2010 at 7:00 PM
This question has been viewed 4995 times so far.
Online URL: http://support.veryant.com/support/phpkb/question.php?ID=121

Powered by PHPKB Knowledge Base Software