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.