Unable to use MS-SQL JDBC Driver

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.

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

Six Stars

Re: Unable to use MS-SQL JDBC Driver

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.