Getting error to connect to Microsoft SQL Server Database

Highlighted
Six Stars

Getting error to connect to Microsoft SQL Server Database

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


Accepted Solutions
Community Manager

Re: Using tOracleCommit with Component List

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
----------------------------------------------------------
Talend | Data Agility for Modern Business

View solution in original post


All Replies
Six Stars

Re: Using tOracleCommit with Component List

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?

 

mssql_driver.jpg

Community Manager

Re: Using tOracleCommit with Component List

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
----------------------------------------------------------
Talend | Data Agility for Modern Business

View solution in original post

Six Stars

Re: Using tOracleCommit with Component List

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.

driver.jpg

Five Stars

Re: Using tOracleCommit with Component List

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
Community Manager

Re: Using tOracleCommit with Component List

@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.
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: Using tOracleCommit with Component List

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

Five Stars

Re: Using tOracleCommit with Component List

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

Six Stars

Re: Using tOracleCommit with Component List

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog