Five Stars

Unable to connect to Microsoft SQL Server

Hi,

I am Unable to connect to Microsoft SQL Server through Talend. It says mssql-jbdc jar missing. Although I have downloaded the JAR, where to put this to be able to connect to SQL server?

mssql_driver.jpg

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars

Re: Unable to connect to Microsoft SQL Server

double check name of driver file, including UpperLower cases, talend critical for name (and check only by exactly matched name)

 

often mistake

  • Different name, Like try to install joda-time-2.8.2.jar when You need joda-time-2.8.1.jar
  • Capital or lowercase laters, like MSsql-jdbc.jar

in Your case jar file name must be exactly mssql-jdbc.jar

-----------
6 REPLIES
Moderator

Re: Unable to connect to Microsoft SQL Server

Hello,

How did you install the driver file mssql-jdbc.jar?

After you have downloaded it, open the Module view ( go to Windows-->Show view-->Talend, and open it), and click the 'Import external jars' button to import it from your local disk.

Here is online document about:TalendHelpCenter:Installing external modules

Best regards

Sabrina

Five Stars

Re: Unable to connect to Microsoft SQL Server

Hi,

I did the same steps as you wrote.

After the 'Import External Jars' step, I refreshed the screen and below is the screenshot which I get. It is showing the JAR is not installed! So, how do I install it then?

missingjar.jpg

Seven Stars

Re: Unable to connect to Microsoft SQL Server

double check name of driver file, including UpperLower cases, talend critical for name (and check only by exactly matched name)

 

often mistake

  • Different name, Like try to install joda-time-2.8.2.jar when You need joda-time-2.8.1.jar
  • Capital or lowercase laters, like MSsql-jdbc.jar

in Your case jar file name must be exactly mssql-jdbc.jar

-----------
Five Stars

Re: Unable to connect to Microsoft SQL Server

Any replies on this please?

Thanks

Pankaj

Seven Stars

Re: Unable to connect to Microsoft SQL Server

???

-----------
Five Stars

Re: Unable to connect to Microsoft SQL Server

Ya that just seemed to work out.. I changed the name of the jar to be exactly 'mssql-jdbc.jar' and it accepted it..

Thanks.