Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo


sun JDBC:ODBC and unixODBC:libmdbodb problems

  • 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