Qlik Community

Ask a Question

Qlik Catalog

Discussion Board for collaboration on Qlik Catalog

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jochem_zw
Partner
Partner

QDC and JDBC error after click on Test Connection

core.error.code.DYNAMIC_CLASS_LOAD_FAILURE - Failed to dynamically load driver and connect : com.microsoft.sqlserver.jdbc.SQLServerDriver

this is my connection string:

jdbc:sqlserver://<HOST>.database.windows.net:1433;database=TestDB

Any idea what's is going wrong and how to fix this?

 

Labels (1)
1 Solution

Accepted Solutions
ThiebaudS
Partner
Partner

Hi,

It's not because database drivers are listed in Admin>Database Drivers that there are actually installed.

You need to download and install the JDBC driver for mssql.

Best regards,

Thiebaud

View solution in original post

7 Replies
ThiebaudS
Partner
Partner

Hi,

It's not because database drivers are listed in Admin>Database Drivers that there are actually installed.

You need to download and install the JDBC driver for mssql.

Best regards,

Thiebaud

View solution in original post

jochem_zw
Partner
Partner
Author

That's right, I already did a installation of the driver in the TomCat home dir and it is working.

 

steffan_holmquist

/usr/local/qdc/apache-tomcat-v.r.nn/lib/

Dan-Kenobi
Partner
Partner

The steps that worked for us were

1. Download the mssql JDBC connector from microsoft's page

https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view...

We got the Microsoft JDBC Driver 7.4 (JRE 8, 11, 12) - download the *tar.gz*, NOT the exe

2. Unzip the driver. You should get a file named mssql-jdbc-7.4.1.jre8.jar among others. copy this one to the TOMCAT_HOME/lib folder

in our case it was: 
# cp mssql-jdbc-7.4.1.jre8.jar /usr/local/qdc/apache-tomcat-7.0.94/lib/

3. With the file copied, shutdown and then start tomcat (don't simply "restart" it. Do this two-step procedure)

 

Test again from the Catalyst UI. It should work fine now.

steffan_holmquist

That is exactly what we did and it worked.  Thank you for the detailed description.

maksim_senin
Partner
Partner

Hi all,

 

For whom it may be useful - I have been struggling whit this error for 2+ hours and finaly managed by only use of SQL Server native user instead of AD one... so, if you use domain users just consider this choice.

jamshed07
Partner
Partner

thank you very much this solution worked for me too. Install mssql-jdbc-9.2.1.jre8.jar 

cp -R /tmp/mssql-jdbc-9.2.1.jre8.jar /usr/local/qdc/apache-tomcat-9.0.38/lib/

Start Tomcat manually
(qdc) $ cd <tomcat home>
$ ./bin/startup.sh

Tomcat can be manually stopped at any time
(qdc) # cd <tomcat home>
(qdc) # ./bin/shutdown.sh