KNIME + JDBC + SQL Server + WinXP64 = :(

Hi!

I'm a windows / sql server guy and Java and JDBC pushes me to my limits and appreciate any help.

 

Everything that I want is to connect Knime to my SQL Server 2008 instance on WinXP 64. (integrated security and I'm admin of everything). 

I downloaded the sqljdbc_3.0.1301.101_enu.exe from MS, unziped it and added a  classpath to sqljdbc.jar.

Did a restart.

If I check Knime's preferences, the only driver definitions that I see are "Derby Emedded ..." 10.0 - 10.2. When I select one and click add there is no MS option to add.

 

 When I drag a Database Reader Node in a project, I only have the sun.* driver.

I know that I'm doing something wrong, but what ?!

 

Thank you!
alelxl

 

Hi Alelxl,

you do not need to change the classpath of KNIME to add anew database driver.

In order to install a JDBC driver in KNIME perform the following steps:

  1. Open KNIME
  2. Go to File->Preferences
  3. In the preferences dialog navigate to KNIME->Database Driver
  4. Use the New... button
  5. Browse for the jdbc.jar file you want to add (e.g. sqljdbc.jar)
  6. Close the preferences dialog using the OK button
  7. That's it

You do not need to restart KNIME. The installed database driver should now be available in the drop down list of all database nodes (e.g. com.microsoft.sqlserver.jdbc.SQLServerDriver).

Bye,

Tobias

Thanks Tobias!

It's always easier than one might think ;)

The integrated auth still doesn't work, despite copying the .DLL. But I just use SQL Auth. It's just a dev machine.

Again, thanks!
alexl

I'd use the 32 bit for starters. Then follow the insturctions I posted in this forum (you have to copy a dll for integrated auth to wok)