topic Error to connect to Microsoft sql server DB (DB version /Microsoft) in Talend Studio

Error to connect to Microsoft sql server DB (DB version /Microsoft)

hiba1 — Sat, 16 Nov 2024 04:55:48 GMT

Hi,

I want to create a new connexion to a Microsoft sql server DB and i set the version DB to "Microsoft".

first i download sqljdbc_6.0.7728.100_enu.tar.gz
This will download a tar.gz archive, which contains 4 different drivers in the enu folder
and i rename sqljdbc42.jar to mssql-jdbc.jar
Then, i install it in Talend Studio,Window -> Show View -> Talend -> Modules -> Click the white bottle / jar and pick-up mssql-jdbc.jar on my hard drive.

after that i configure the tcp/ip

i check the connexion but i got this error

Any help please !

Re: Error to connect to Microsoft sql server DB (DB version /Microsoft)

JR1 — Mon, 19 Aug 2019 14:18:24 GMT

Is there any specific reason why you import your very own jars for connecting to MSSQL? Talend will use appropriate jars if you create tMSSQLXXXX components. But maybe you have a reason for that. Importing the jars into Talend Studio is not enough. You will have to load them in your job by using a tLibraryLoad component as the first step in your job.

Re: Error to connect to Microsoft sql server DB (DB version /Microsoft)

hiba1 — Mon, 19 Aug 2019 14:26:14 GMT

When Microsoft is selected, you must download the Microsoft JDBC Driver for SQL Servers from the Microsoft Download Center. You must then uncompress the zip installer file, choose a .jar file in the uncompressed folder, depending on your version of JRE, rename the .jar file to mssql-jdbc.jar and install it. For more information on choosing the .jar file, see the requirements on the Microsoft Download Center.

I did not create jobs yet...i just want to create a new connexion in the Metadata.... it works fine whene i set the DB version to "open source JTDS"...but with Microsoft it failed .

Re: Error to connect to Microsoft sql server DB (DB version /Microsoft)

JR1 — Mon, 19 Aug 2019 14:35:57 GMT

Ah, sorry. I did not know that you have to install MS jars manually (you never stop learning). Unfortunately, I cannot tell you what's wrong with what you are doing as it seems to be the right way to do it.

Anyone?

Re: Error to connect to Microsoft sql server DB (DB version /Microsoft)

hiba1 — Mon, 19 Aug 2019 14:44:44 GMT

thanks for your reply