I am having some issues with getting a connection from KNIME to SQL Server (using sqljdbc4.jar) once I configure the Database Reader Node I see:
WARN Database Reader java.sql.SQLException: java.util.concurrent.TimeoutException
- Setting a longer timeout in Knime.ini -Dknime.database.timeout=100
- Tried setting a Java VM Argument in Knime.ini (maybe this does not belong here or I have syntax error) -- -Djava.library.path="C:\\Users\\Dennis\\Desktop\\Dropbox\\Database Drivers\\sqljdbc_4.0\\enu\\sqljdbc_auth.dll"
- Tried downloading JDTS driver from http://sourceforge.net/projects/jtds/files/jtds/1.3.1/ (I am not sure if I need to do anything more than remove sqljdbc4.jar and add the jtds-1.3.1.jar under drivers and restart knime)
So at this point I suspect user error, as I thought one of these options would work. Any thoughts?