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

ssms pentaho pentaho-spoon data-integration
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

Related questions

How do I set a column value to NULL in SQL Server Management Studio?

How do I clear the value from a cell and make it NULL?

Read More
How to find server name of SQL Server Management Studio

I installed Microsoft SQL Server 2008. When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with a blank textbox for Server name. I have tried a lot of names, but I couldn't solve it. …

Read More
Insert Data Into Temp Table with Query

I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this? Here is an …

Read More