[resolved] "Driver not found" using MS SQL Server in the 1st Talend config screen

One Star

[resolved] "Driver not found" using MS SQL Server in the 1st Talend config screen

"Driver not found" using MS SQL Server in 1st Talend config screen, preventing me from getting to login button.
Under the Driver and URL settings I am seeing:
Driver     Driver not found.  (see installation guide for more information)
URL        Driver not found.   (see installation guide for more information)
The other 3 after that all report the (i) Information icon and appear ok.
How exactly do I address and remediate this condition?  I am not expert in JDBC drivers.
Thanks

Accepted Solutions
Four Stars

Re: [resolved] "Driver not found" using MS SQL Server in the 1st Talend config screen

Hi John,
1) You can use load library component to load sqljdbc4.jar.. or
2) You can put in your talendPath(TOS_DI-r97954-V5.3.0M2\lib\java)\lib\java
3) You can download jar from http://www.java2s.com/Code/Jar/s/Downloadsqljdbc420jar.htm
Thanks
Vaibhav

All Replies
Four Stars

Re: [resolved] "Driver not found" using MS SQL Server in the 1st Talend config screen

Hi,
You will be needing following for SQL Server jdbc connectivity using talend
JDBC_JdbcUrl=jdbc:sqlserver://localhost:61755;databaseName=
JDBC_DriverJar=sqljdbc4.jar
JDBC_ClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC_Login=username
JDBC_Password=yourpassword

Use above and make sure that the required JDBC driver jar is available inside the talend lib or required folder.
Vaibhav
One Star

Re: [resolved] "Driver not found" using MS SQL Server in the 1st Talend config screen

What is the actual path to the "required folder" and where is the talend lib located and where can I download the SQLJDBC4.jar file?
Thanks for your assistance.
John
Four Stars

Re: [resolved] "Driver not found" using MS SQL Server in the 1st Talend config screen

Hi John,
1) You can use load library component to load sqljdbc4.jar.. or
2) You can put in your talendPath(TOS_DI-r97954-V5.3.0M2\lib\java)\lib\java
3) You can download jar from http://www.java2s.com/Code/Jar/s/Downloadsqljdbc420jar.htm
Thanks
Vaibhav

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now