I am new to KNIME and would like to setup a workflow using an MS SQL database connection.
I read all the instructions and forum posts I could find related to this.
My connection string looks like this: "jdbc:sqlserver://nrusca-s4393.subdomain.companyname.net:1433/Test" (subdomain and company name substituted).
I verified both port (1433) and database name as well as user name and password, but I'm still getting following error message:
"java.sql.SQLException: java.sql.SQLException: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0"
sqljdbc4.jar (as well as sqljdbc.jar) is listed in the "Database Driver" tab of the KNIME configuration and is at the top of the list. I also tried to manually add a separate sqljdbc4.jar that I downloaded from Microsoft, but the problem persists.
I'm not sure why it does not find sqljdbc4.jar, as it is clearly present and seems to be configured properly. I also tried adding sqljdbc4.jar and sqljdbc.jar to the CLASSPATH variable, but it didn't help.
I appreciate your help.