You can translate the question and the replies:

Driver not found

Hi, after follwoing the steps in the guide (https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Azure%20SQL%20Data%20Warehouse%20from%20Denodo?category=Data+Sources) I always get the same error message:"Unable to establish connection. Driver not found". Even when selecting different drivers from my local files (C:\Denodo\DenodoPlatform7.0\lib\extensions\jdbc-drivers\mssql-jdbc-7.x): "mssql-jdbc-7.2.2.jre8" or "mssql-jdbc-8.4.1.jre8" it keeps on not finding the driver. Other than that all the standards are set: Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver Database URI: jdbc:sqlserver:XXX.database.windows.net:1433;database=dvscenario I don't know where the mistake is hidden. Tahnk you for your support, Matthias

Azure Azure SQL DB Driver

user
14-12-2020 09:59:15 -0500

2 Answers

Hi, I was able to successfully test and create a Microsoft SQL server datasource using the JDBC connection string as follows: > jdbc:sqlserver://<hostname>:1433;databaseName=<dbname> Hence, I would suggest you to modify your connecting String by adding a double forward slash (//) before the hostname and then test the connection. For more information, please refer to the section [**Importing JDBC Sources**](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#importing-jdbc-sources) of Virtual DataPort Administration Guide. Hope this helps!

Denodo Team
15-12-2020 06:22:58 -0500

It was as easy as that...thank you!

user
15-12-2020 07:08:57 -0500

ADD ANSWER

You must sign in to add an answer. If you do not have an account, you can register here