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

  • Talend Studio
7 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
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