2

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

CD9999
  • 109
  • 1
  • 3
  • 14

2 Answers2

1

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

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

Godwin
  • 400
  • 3
  • 15
0

I think the fact is not specific related to pentaho, else, to Java. The native connection type for java is JDBC, since Java 8, ODBC support was removed, so you may need jdbc2odbc bridge driver to connect ODBC datasources, but as far as I know, the only working solution is not open.

You can see more details here.

ChoCho
  • 439
  • 5
  • 13