How to Upgrade a the MSSQL JDBC Driver

[dominik4]

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

[Anonymous]

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

[HShakira1616128108]

1. alaskasworldCall the SQLServerDatabaseMetaData methods getDriverMajorVersion, getDriverMinorVersion, or getDriverVersion.
2. 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