Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about Teams
Ask 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.)
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
.
Thanks for contributing an answer to Stack Overflow!
-
Please be sure to
answer the question
. Provide details and share your research!
But
avoid
…
-
Asking for help, clarification, or responding to other answers.
-
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our
tips on writing great answers
.
