topic Re: Getting error to connect to Microsoft SQL Server Database in Installing and Upgrading

Getting error to connect to Microsoft SQL Server Database

Anonymous — Sat, 16 Nov 2024 09:37:03 GMT

I am trying to create a DB connection with Microsoft SQL Server Database. But I am getting the error. can you suggest?

Re: Getting error to connect to Microsoft SQL Server Database

Anonymous — Mon, 19 Jun 2017 07:52:45 GMT

Refering to my above question, If I select the DB version as Microsoft, then I get the follwowing error:

Also I have downloaded the sqljdbc.jar. But where should I put it to get rid of the error?

Re: Getting error to connect to Microsoft SQL Server Database

Anonymous — Mon, 19 Jun 2017 08:06:32 GMT

Hello
You need to download and install the driver file mssql-jdbc.jar in order to finish
creating MSSQL server metadata or use MSSQL server components in studio. After you have downloaded it, open the Module view (if it does not appear, go to Windows-->Show view-->Talend, and open it), and click the 'Import external jars' button to import it from your local disk.

Regards
Shong

Re: Getting error to connect to Microsoft SQL Server Database

Anonymous — Tue, 20 Jun 2017 07:45:17 GMT

OK, I do exactly the same. But still I get the same error.

Also I am using Talend 6.3 for Data Integration and I am using Java8. So see the screenshot and suggest.

Re: Getting error to connect to Microsoft SQL Server Database

Anonymous — Tue, 20 Jun 2017 22:56:05 GMT

I am also facing similar issue, i installed the sqljdbc41.jar jar file for mssqlserver database but still facing issue in connecting to the DB connection in metadata

Re: Getting error to connect to Microsoft SQL Server Database

Anonymous — Wed, 21 Jun 2017 02:34:25 GMT

@ppp_rrr, I think you have resolved the problem after you rename the jar file to mssql-jdbc.jar and install it to studio.
@shobhitj, please install the right jar file according to the DB version you select.

Re: Getting error to connect to Microsoft SQL Server Database

Anonymous — Wed, 21 Jun 2017 05:59:43 GMT

Ya exactly, just make sure you have the exact JAR file required(same name) and your problem should be resolved.

Re: Getting error to connect to Microsoft SQL Server Database

Anonymous — Wed, 21 Jun 2017 19:28:33 GMT

Thanks, changing the jar file name to mssql-jdbc.jar and placing in right java version directory helped. Able to connect now.Thanks @shong & @ppp_rrr

Re: Getting error to connect to Microsoft SQL Server Database

Anonymous — Fri, 07 Jun 2019 08:34:39 GMT

hi i am getting same error bro,can you please how you did that? after replacing file name where we kept that jar file?please help me out