SQL JDBC driver not found when executing from a batch file

KNIME Analytics Platform
#1

I've created a KNIME workflow that connects to an SQL Server database. It works fine but when I try to execute the workflow from a batch file on a Windows machine I get the following error:

Execute failed: Could not create connection to database: Could not find driver class: com.microsoft.sqlserver

I've added the path where the .jar files are located but it doesn't help. Any ideas?

#2

Got it sorted. Had to export the preferences and then include it as a parameter which preferences file to use.

#3

Hi Willem,

sorry for the delay in response and great you figured it out on your own.

Best, Iris

#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.