ERR_SQL_CANNOT_LOAD_DRIVER

david1002liu

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.

Sergey

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): 

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

Sergey

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

david1002liu

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.

Sergey

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.

david1002liu

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.

david1002liu

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

david1002liu

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?