support: Customer Portal
Focused on delivering choice, investment protection and flexibility to organizations with valuable COBOL assets
  

Veryant Knowledge Base
Home > All Categories > Data Access > RDBMS > Where is the Microsoft SQL Server 2005 JDBC Driver?
Question 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 Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu" which will contain the sqljdbc.jar file. 

You will need to add "C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.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 This question has been viewed 6520 times so far.
Click Here to View all the questions in RDBMS category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
How helpful was this article to you?
User Comments User Comments Add Comment
There are no user comments for this question. Be the first to post a comment. Click Here
Related Questions Related Questions
  1. How do I set up JDBC to communicate with Oracle database?
  2. Trying to work with MS SQL I get the error "JRE (Java Runtime Environment) version 1.7 is not supported by this driver. use classlibrary sqljdbc4.jar witch supports JDBC 4.0".
  3. Does Oracle Pro*COBOL work with isCOBOL?
  4. Does isCOBOL have a utility to migrate Vision files to MS-SQL and PostgreSQL ?
  5. Where can I get products and services for Postgres (PostgreSQL)?
  6. Can isCOBOL access Oracle, MS SQL and other RDBMS?
Article Information Additional Information
Article Number: 67
Created: 2009-09-02 12:08 PM
Rating: 1 Star
 
Article Options Article Options
Print Question Print this Question
Email Question Email Question to Friend
Export to Adobe PDF Export to PDF File
Export to MS Word Export to MS Word
Bookmark Article
Subscribe to Article Subscribe to Article
 
Search Knowledge Base Search Knowledge Base

  Knowledge Base Home


 
 

© Veryant - All Rights Reserved
Veryant and isCOBOL are trademarks or registered marks of Veryant in the United States and other countries. All other marks are the property of their respective owners.