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
Can anybody tell me what i am doing wrong?