I am trying to connect to a MSSQL database with server name as:
prod-companyx-workplace-resources.database.windows.net
with a specific login creds and a database name.
If I use a Microsoft SQL Server Connector node it gives me :
ERROR Microsoft SQL Server Connector 0:16 Execute failed: Client driver version is not supported.
How would I go about solving it!
Hi there @shubhamss ,
what driver are you using? Make sure you follow instruction from database guide how to register driver properly
https://docs.knime.com/latest/db_extension_guide/index.html#intro
Br,
Ivan
The thing is, it is not local database. The guidelines showcase how to local db mssql db.
ERROR DB Connector 0:17 Execute failed: Selected JDBC driver does not support given JDBC url.
In the description is the Database URL. I made a Python version
which works like a charm.
Hi there @shubhamss ,
glad to see you found a workaround! To connect to Azure SQL Database from KNIME check this topic:
Hello,
I am using Knime and I would like to connect to the Azure Database.
I tried the Microsoft SQL Server Connector node and encountered an error.
ERROR Microsoft SQL Server Connector 0:1 Execute failed: Failed to load ADAL4J Java library for performing ActiveDirectoryPassword authentication.
I have downloaded the ADAL4J from Microsoft including the dependencies and also the JDBC driver from Knime installation marketplace.
I have tried the following:
Create a plugin and include t…
Br,
Ivan
Hi @shubhamss ,
can you provide little more information on how you configured the nodes (Microsoft Sql Connector and DB Connector)? From preference page everything looks fine so far.
1 Like
system
Closed
May 21, 2020, 1:04pm
7
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.