ODBC driver and GUI

2007-05-08
2013-05-01
  • Hi,
    i have installed and configured unixODBC and MDBTOOLS.
    There are a lot of GUI sdministration tools. I use ODBCConfig, it works fine.

    But I have a problem...

    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