topic Re: Unable to use MS-SQL JDBC Driver in Installing and Upgrading

Unable to use MS-SQL JDBC Driver

Anonymous — Sat, 16 Nov 2024 08:00:26 GMT

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.

Re: Unable to use MS-SQL JDBC Driver

Anonymous — Thu, 05 Jul 2018 05:10:10 GMT

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

db Version Open source JTDS

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

Re: Unable to use MS-SQL JDBC Driver

Anonymous — Thu, 05 Jul 2018 15:40:10 GMT

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

Re: Unable to use MS-SQL JDBC Driver

Anonymous — Fri, 06 Jul 2018 02:35:33 GMT

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