14,494 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Those are very old and not recommended versions.
To Check Sql jdbc driver version
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 95%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
senthil madhan
1
Reputation point
HI Team,
We are using SQL server "Microsoft SQL Server 2017 - 14.0.3370 as our Database .1".For Integrating with informatica the below jdbc version has to be installed in my machine.
sqljdbc_4.2.8112.200
sqljdbc_6.0.8112.200.
I am not sure what is the jdbc version I am running with now ,Could you please help us in knowing what is the version deployed in my machine?
Thanks
Senthil Madhan T
SQL Server | Other
{count} votes
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2022-01-21T07:07:33.013+00:00 Hi @senthil madhan ,
We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Sign in to comment
2 answers
Sort by: Most helpful
-
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
2022-01-20T01:50:04.537+00:00 Hi @senthil madhan ,
The version of the installed Microsoft JDBC Driver for SQL Server can be found in the following ways:
•Call the SQLServerDatabaseMetaData methods getDriverMajorVersion, getDriverMinorVersion, or getDriverVersion.
•The version is displayed in the readme.txt file of the product distribution.Also, the JDBC driver name can be returned from the getDriverName method call on the SQLServerDatabaseMetaData class. It will return, for example, "Microsoft JDBC Driver 6.4 for SQL Server".
Refer to MS document Getting the driver version to get more.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.