topic How to Upgrade a the MSSQL JDBC Driver in Installing and Upgrading

How to Upgrade a the MSSQL JDBC Driver

dominik4 — Sat, 16 Nov 2024 00:45:06 GMT

Hi Community,

when I create a new Connection in Talend Studio I can choose a DB Type. Than I can choose Microsoft SQL Server - Microsoft and have to insert the parameters. Host etc.

Where can I see which driver is "behind" Microsoft SQL Server - Microsoft? And how do upgrade this driver?

Thank you

Dominik

Re: How to Upgrade a the MSSQL JDBC Driver

Anonymous — Fri, 29 Jan 2021 03:45:47 GMT

Hello,

Could you please clarify in which Talend version/edition you are?

Here is online documentation for V 7.3.1 about: TalendHelpCenter: Supported Third-Party System/Database/Business Application Versions

There are two kinds of DB_type for MSSQL database supported: JTDS and Microsoft

Open source JTDS (The jar of driver is jtds-1.3.1-patch.jar)

Microsoft sql server (The jar of driver is mssql-jdbc.jar)

Best regards

Sabrina

Re: How to Upgrade a the MSSQL JDBC Driver

HShakira1616128108 — Fri, 19 Mar 2021 04:32:58 GMT

alaskasworldCall the SQLServerDatabaseMetaData methods getDriverMajorVersion, getDriverMinorVersion, or getDriverVersion.
The version is displayed in the readme. txt file of the product distribution.

In addition, the JDBC driver name can be returned from the getDriver name method call on the SQLServerDatabaseMetaData class. It will return, for example, "Microsoft JDBC Driver 6.4 for SQL Server".

alaskasworld