sun.jdbc.odbc.JdbcOdbcDriver not found

Hello Martin,

you are probably running Mashzone under Java 8, which does not contain the JBDC-ODBC bridge anymore. Thus, newer releases of Mashzone do not provide the driver class in the select box shown above.

If you want to get data from a MS Access database you will have to use a 3rd party JDBC driver which can be found on the web. If you have found an adequate driver lib, please put it in the "jdbcdrivers" folder of your installation and restart Mashzone.

Hope this helps.

Best regards,

Gerhard

Hi Gerhard,

I am also facing the similar issue. I am trying to connect the Oracle DB 11g.

When I am trying to connect, I am getting the error : Unable to find JDBC driver class "sun.jdbc.odbc.JdbcOdbcDriver" connecting to database

I placed the rt.jar under : <installation_Directory>/ppmmashzone/server/bin/work/work_mashzone_m/mashzone_data/jdbcdrivers

Still I am facing the issue.

​Thanks

Bala

Hi Bala,

for connecting an Oracle 11g, you do not need the JDBC-ODBC bridge. You should better take the original JDBC driver provided by oracle, e. g. ojdbc6.jar. If you put this file into the 'jdbcdrivers' folder you mentioned above, you should be able to connect Oracle with an URL like this:

jdbc:oracle:thin:@localhost:1521/ORCL 

Just adjust your host, port and SID and enter your credentials on the DB connection page.

Best regards,

Gerhard

Hi Bala,

one thing to add: You must select the right driver class on the DB connection admin page when adding a new DB connection. For Oracle this is oracle.jdbc.OracleDriver.

Best regards,

Gerhard