Where to download sun.jdbc.odbc.JdbcOdbcDriver (trying to connect output csv from Spoon to SSMS)

Question

I have a csv that I have transformed in Kettle/Spoon/PDI and I am trying to output it to SSMS.

In Spoon, it's a two step process: read the csv (and edit a couple types), then output to SQL.

I get this error: "Driver class 'sun.jdbc.odbc.JdbcOdbcDriver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed. sun.jdbc.odbc.JdbcOdbcDriver"

I can't seem to find where to download this driver. (Have googled it obviously, though perhaps not enough.)

Solution

http://www.java2s.com/Code/JarDownload/jdbc/jdbc.jar.zip

link to download sun.jdbc.odbc.jdbcodbcdriver jar file

Comments

[Primit]

Add this driver to "lib" folder of your pdi and restart spoon

[gumuruh]

is that for java to ms access?

[Ajeesh]

sun.jdbc.odbc.jdbcodbcdriver not available