ERR_SQL_CANNOT_LOAD_DRIVER

david1002liu
david1002liu Registered Posts: 12 ✭✭✭

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

Best Answer

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
    edited July 17 Answer ✓

    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.

Answers

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 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

  • david1002liu
    david1002liu Registered Posts: 12 ✭✭✭

    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
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 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.

  • david1002liu
    david1002liu Registered Posts: 12 ✭✭✭

    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
    david1002liu Registered Posts: 12 ✭✭✭

    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
    david1002liu Registered Posts: 12 ✭✭✭

    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?

Setup Info
    Tags
      Help me…