KNIME SQL Server connection no longer working

[JWebb]

Hello,

I updated to v4.6 this morning and now none of my SQL server connections work. “Execute” is greyed out and I have an error message I do not understand:

WARN Microsoft SQL Server Connector 5:114:49 To register the driver go to File->Preferences. In the preferences go to KNIME->Databases and register a new driver for the database type mssqlserver by clicking on the Add button.
WARN Microsoft SQL Server Connector 5:114:49 Please register a compatible driver via the KNIME preference page. (For details see the log file)

I am not sure what this means and the instructions are not clear to me. I cannot figure out what to do after clicking the Add button as instructed. Can anyone in the know help? Most of my workflows connect to source data using this! Thank you.

[ArjenEX]

Hi @JWebb

Closing and re-opening your KNIME should resolve it. This is a known thing with the V4.6 update.

DBDriver Registry Error after updating to KNIME 4.6

I just updated to KNIME 4.6, and now I can’t connect to my Microsoft SQL Server Database. Here’s a list of some of the errors and warnings that populate when I try to run my workflow. Any suggestions on how to fix this? ERROR DBDriverRegistry Database driver wrapper creation failed for driver (H2) "H2". ERROR DBDriverRegistry Failed to load built-in database driver (H2) "H2" from extension org.knime.database.extensions. ERROR DBDriverRegistry Databas…

MYSQL Drivers Un-Installed

Hello, When I installed the new version of KNIME (4.6.0), all the previous installed MYSQL drivers were un-installed. As a result, 90% of my KNIME workflows cannot be run, because I cannot connect to MYSQL. Please help, Alex

Database Driver isnt´t load after installing the new KNIME Version 4,6

Hi, i have a problem after installing the new Version of KNIME 4.6. I can´t choose the special Database Driver in the DB Connector node. [p1 DB Connector] [P2 KNIME Preference] Thank you in advance for your help Greetings

[JWebb]

How strange! I restarted at least twice (including once to try and get the drivers back) and nothing happened…but closing and re-opening has worked!

Panic over Thanks!