Microsoft Sql Server

isCOBOL Evolve : SDK User's Guide : Programming Guides : JDBC : Common Driver and URL settings : Microsoft Sql Server

Library:

sqljdbc4.jar

Value for iscobol.jdbc.driver:

com.microsoft.sqlserver.jdbc.SQLServerDriver

Value for iscobol.jdbc.url:

jdbc:sqlserver://<ServerName>:<Port>;user=<UserName>;password=<Password>;encrypt=false;DatabaseName=<DatabaseName>

NOTE - A third party pure java JDBC driver is also available for Microsoft Sql Server. Its name is JTDS and it can be found at the following website: http://jtds.sourceforge.net.

Library:

jtds-1.2.5.jar

Value for iscobol.jdbc.driver:

net.sourceforge.jtds.jdbc.Driver

Value for iscobol.jdbc.url:

jdbc:jtds:sqlserver://<ServerName>:<Port>/<DatabaseName>;user=<UserName>;password=<Password>