Unable to use MS-SQL JDBC Driver

[Anonymous]

Hello,

    I'm trying to install and use Microsoft's JDBC driver instead of the Talend-provided one. I followed:

https://community.talend.com/t5/Installing-and-Upgrading/Getting-error-to-connect-to-Microsoft-SQL-S...

But I do not have the "DB Version" drop-down option in my DB Connection wizard or tMSSql components.

 I'm using Talend Data Integrator v6.1

Any help would be greatly appreciated.

[Anonymous]

If you've registered the driver with Talend you're nearly there

db Version Open source JTDS

con: jdbc:jtds:sqlserver//ipnumberort/dbname;

[Anonymous]

@jcruie thank for your reply. However, the open source driver is what I do NOT  want. I need to use the Microsoft-provided drive (com.microsoft.sqlserver.jdbc.....).  How do I get Talend to register/recognize it and make it and option in the DB connection.

[Anonymous]

jdbc:sqlserver://localhost:1433;DatabaseName=yourdbname;