Connecting to MS Access database using JDBC, no data found

[Former Member]

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?

[former_member11696]

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...