Skip to Content
Former Member
Aug 24, 2010 at 11:51 AM

Connecting to MS Access database using JDBC, no data found


I'm developing an application in Java that is able to generete reports. To get my application working i need to switch out the ODBC connection en switch over to a JDBC connection.

When using the ODBC connection everything works as supposed to. When i use a JDBC connection, using the same ODBC data source, it returns the SQL exception:"no data found".

My JDBC settings look like this:

Connection URL: jdbc:odbc:test2

DataClass: sun.jdbc.odbc.JdbcOdbcDriver

Can anybody tell me what i am doing wrong?