tCreateTable ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver with both JDK1.7 and JDK 1.8

[Anonymous]

I'm trying to use tCreateTable to create table but get below error. I tried use JDK 1.7 and UCanAccess, but still get the same error. Please help!

[statistics] connected
Exception in component tCreateTable_1
java.lang.RuntimeException: Creating table failed
at local_project.test_0_1.test.tCreateTable_1Process(test.java:348)
at local_project.test_0_1.test.runJobInTOS(test.java:590)
at local_project.test_0_1.test.main(test.java:447)
Caused by: java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at local_project.test_0_1.test.tCreateTable_1Process(test.java:320)
... 2 more

[Anonymous]

Ok, sorry. I will do that. Ignore the first comment

---

@TRF wrote:

What if you try to drop the table first (using tMSSQLRow) then create it (using tCreateTable)?

---

[TRF]

Hum... did you try to drop/create the table using tMSSQLOutput component?

[Anonymous]

Thank you a lot TRF,

the problem was in the user credeltials as you commented in the first answer. 

Now it works without any problem.

Tanks!!!

[TRF]

Great!

Don't forget to select the answer which solved the topic - Kudos also appreciated.