JCHEM manager - different driver.

#1

Hello,

Is there anyway I would be able to use different driver to connect myself to the database then the one provided in JCHEM MANAGER NODE?

In JCHEM standalone version I have this possibility of choosing custom driver, and in KNIME NOD - JCHEM MANAGER I can not connect to the database with default driver.

Regards

0 Likes

#2

What is the different driver?
Could you please let me know what you want is in more detail to solve the issue?

Best regards,
Taka
 

0 Likes

#3

JCHEM Manager node is using its own driver (You have option to choose which driver You want to use - either for oracle, mysql, ms sql etc), and using his default driver for MS SQL I am unable to connect to the database from KNIME. IN standalone version of JCHEM I can choose different driver so I am able to connect to the database with non - default driver (i am trying to do so without authentication).

 

0 Likes

#4

I think that you can override the following file with your JDBC driver.
 <KNIME_dir>plugins\jp.co.infocom.cheminfo.jchemlib_5.4.1.1\lib\jdbc\sqljdbc.jar

And their package must be 'com.microsoft.sqlserver.jdbc'.

Best regards,
Taka
 

0 Likes

#5

Thanks Taka! But actually after restarting my computer suddenly everything is working - without driver overriding. Weird....

0 Likes