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.
Best Answer
-
Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 DataikerOptionsMS 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.
Answers
-
Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 DataikerOptions
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
-
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 Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 DataikerOptions
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.
-
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.
-
The version of MSSQL that I am trying to connect to is Microsoft SQL Server 2008 R2, which should be the version 10.5
-
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?