Six Stars

Unable to use MS-SQL JDBC Driver

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.

MSConn.jpg

 I'm using Talend Data Integrator v6.1

Any help would be greatly appreciated.

3 REPLIES
Five Stars

Re: Unable to use MS-SQL JDBC Driver

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

db Version Open source JTDS

con: jdbc:jtds:sqlserver//ipnumberSmiley Tongueort/dbname;

Six Stars

Re: Unable to use MS-SQL JDBC Driver

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

Five Stars

Re: Unable to use MS-SQL JDBC Driver

jdbc:sqlserver://localhost:1433;DatabaseName=yourdbnameCapture.PNG;