MS SQL server Driver issue

Solved!
Siva_sai
Level 1
MS SQL server Driver issue

Hi All,



I'm trying to create a MS SQL server connection and end up with following error. Can someone please help me to fix this error.



0 Kudos
1 Solution
Clรฉment_Stenac
Hi,

You need to download and instal the JDBC driver as explained here:

https://doc.dataiku.com/dss/latest/troubleshooting/errors/ERR_SQL_CANNOT_LOAD_DRIVER.html

View solution in original post

4 Replies
Clรฉment_Stenac
Hi,

You need to download and instal the JDBC driver as explained here:

https://doc.dataiku.com/dss/latest/troubleshooting/errors/ERR_SQL_CANNOT_LOAD_DRIVER.html
Siva_sai
Level 1
Author
Thanks for the quick reply Stenac. I followed all the steps provided in that link already but still no luck.

Can we connect to MS SQL server with 2 weeks trail version license?
0 Kudos
Clรฉment_Stenac
Hi, yes you can connect with the trial license.

Have you checked that in the "lib/jdbc" subfolder of the DSS datadir, you now have a "mssql-something.jar" ? Have you restarted DSS after adding it ? Is the error message exactly the same ? Can you attach a screenshot of both the error and the contents (ls -l) of lib/jdbc?
0 Kudos
Siva_sai
Level 1
Author
Thanks a lot Stenac. My bad, I copied the files into DataIKU/dataiku-dss-5.1.4/lib/jdbc instead of DataIKU/DATA_DIR/lib/jdbc path. Now I moved it to correct path and it's working fine.
0 Kudos

Labels

?
Labels (2)
A banner prompting to get Dataiku