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
1 ACCEPTED SOLUTION

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
3 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