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

CD9999 picture CD9999 · Aug 7, 2018 · Viewed 17.6k times · Source

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.)

Answer

Godwin picture Godwin · Aug 8, 2019

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

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