Antonello Parente - 2007-05-08

Hi,
I'm not able to connect 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