Join us on Wednesday, June 3rd for a deep dive into Customer Predictive Analytics Learn more

MS SQL server Driver issue

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
4 Replies
Dataiker
Dataiker
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
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
Dataiker
Dataiker
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
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 (2)