Title: Where is the Microsoft SQL Server 2005 JDBC Driver?
Question:

I installed Microsoft SQL Server 2005, but I can't find the SQL Server JDBC Driver. Where is it located?

Answer:

Visit the Microsoft SQL Server 2005 JDBC Driver home page at http://msdn2.microsoft.com/en-us/data/aa937724.aspx

Click on the download link and follow the instructions. After installation you will find the directory, "C:Program FilesMicrosoft SQL Server 2005 JDBC Driversqljdbc_1.2enu" which will contain the sqljdbc.jar file. 

You will need to add "C:Program FilesMicrosoft SQL Server 2005 JDBC Driversqljdbc_1.2enusqljdbc.jar" to CLASSPATH and specify the following in the isCOBOL properties file:
iscobol.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
iscobol.jdbc.url=jdbc:sqlserver://192.168.1.10:1433;databaseName=mydbname
replacing 192.168.1.10 with your server hostname or IP address, and mydbname with the name of your database.
Authored by: Veryant Support on Wed, Sep 2nd, 2009 at 7:00 PM
This question has been viewed 5676 times so far.
Online URL: http://support.veryant.com/support/phpkb/question.php?ID=67

Powered by PHPKB Knowledge Base Software