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, but I can't find the SQL Server JDBC Driver. Where is it located?

Answer:
Visit the Microsoft SQL Server JDBC Driver home page at https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

Click on the download link extract the files for your environment. After extracting, you can find the directory, "sqljdbc2_x.xenu", with the version you downloaded replacing the "x.x" in the foldername. You will find several .jar files in this directory. Use the one that is the same or less than your JRE version.

This jar file must be in the CLASSPATH. The easiest way to do this is to put the jar file in the %ISCOBOL%jars (or $ISCOBOL/jars) folder.

Then set the jdbc.driver and jdbc.url in your properties file. There is a list of common driver and URL settings in isCOBOL's documentation under isCOBOL Evolve/SDK User's Guide/ Programming Guides/JDBC

For instance, the common SQL Server settings would be:

   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 8443 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. Where can I get products and services for Postgres (PostgreSQL)?
  5. 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



 
 

© 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.