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

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

Anonymous — Sat, 16 Nov 2024 11:33:28 GMT

"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

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

Anonymous — Sat, 02 Aug 2014 07:48:17 GMT

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

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

Anonymous — Sat, 02 Aug 2014 12:10:05 GMT

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

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

Anonymous — Sat, 02 Aug 2014 13:14:22 GMT

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