Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sun.jdbc.odbc unixODBC mdbtools conflicts

843859May 8 2007 — edited May 8 2007
Hi,
I'm not able to connect sun.jdbc.odbc bridge to unixODBC data source.
I have a .mdb database linked to unixODBC by linmdbodbc.

I try the connection using isql <data_source_name> and it works fine.

When i try to connect by my java application it does'nt work:

if I write:
con = DriverManager.getConnection("jdbc:odbc:<data_source_name>");

it throws an sql exception:

The result set type is not supported.

If I write

con = DriverManager.getConnection("jdbc:odbc:Driver{<Driver_Name>};DBQ=<database_filename>");

it throws an sql exception

[unixODBC][Driver Manager]Data source name not found, and not default driver specified.

Please Help me

Antonello Parente
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2007
Added on May 8 2007
3 comments
351 views