Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

ERR_SQL_CANNOT_LOAD_DRIVER

Solved!
david1002liu
Level 1
ERR_SQL_CANNOT_LOAD_DRIVER

I followed the instructions on https://doc.dataiku.com/dss/8.0/installation/jdbc.html and installed the jar file for mssql. However I am still receiving this error.

Capture.PNGCapture1.PNG

0 Kudos
1 Solution
sergeyd
Dataiker
Dataiker

MS SQL 9.2 JDBC driver works for me: 

[centos@ip-172-31-13-245 ~]$ ll dss/lib/jdbc/
total 1300
-rw-r--r-- 1 centos centos 1327629 Jun  2 14:31 mssql-jdbc-9.2.1.jre8.jar

and the connection is successful (but I used MS SQL 2019): 

Screenshot 2021-06-02 at 17.54.05.png

So looks like JDBC driver 9.2 is not working with MS SQL 2008. DSS has nothing to do here at this point. 

View solution in original post

0 Kudos
7 Replies
sergeyd
Dataiker
Dataiker

Hi @david1002liu 

I see that you have added JDBC driver version for Java 11. Is the same version used for DSS? Please also make sure that DSS system user can access this JDBC file.

Also, please make sure to restart DSS so the driver will be loaded to the classpath. 

Thanks

0 Kudos
david1002liu
Level 1
Author

I did all those and still getting the error. I am using DSS on a ubuntu virtual machine. I also tried to manually set the class path using export CLASSPATH="/home/user/DATA_DIR/lib/jdbc/mssql-jdbc-9.2.1.jre11.jar" and is still not working.

0 Kudos
sergeyd
Dataiker
Dataiker

Thanks. I assume you are using DSS8.0.x (based on the docs link you used). Please let me know the precise DSS version and MSSQL version you are trying to connect to. 

0 Kudos
david1002liu
Level 1
Author

Thanks for the reply, I am using DSS Version 8.0.2 and the cannot load driver error shows up even when I just type in an arbitrary host name.

0 Kudos
david1002liu
Level 1
Author

The version of MSSQL that I am trying to connect to is Microsoft SQL Server 2008 R2, which should be the version 10.5

0 Kudos
david1002liu
Level 1
Author

I switched to version 7.2 jdbc driver and is now working, however it didnt work before even with an arbitrary server. Is dataiku not supporting the Microsoft JDBC Driver 9.2 for SQL Server?

0 Kudos
sergeyd
Dataiker
Dataiker

MS SQL 9.2 JDBC driver works for me: 

[centos@ip-172-31-13-245 ~]$ ll dss/lib/jdbc/
total 1300
-rw-r--r-- 1 centos centos 1327629 Jun  2 14:31 mssql-jdbc-9.2.1.jre8.jar

and the connection is successful (but I used MS SQL 2019): 

Screenshot 2021-06-02 at 17.54.05.png

So looks like JDBC driver 9.2 is not working with MS SQL 2008. DSS has nothing to do here at this point. 

View solution in original post

0 Kudos
A banner prompting to get Dataiku DSS