ODBC driver and GUI

  • pabloj

    I've read the postings in the devel mailinglist and would ask the mantainer to please keep on supporting ODBC driver for unix, and possibly the GUI, even if, having the ODBC driver working unixODBC gui could be used instead.
    Thanks for your attention (and time!)

    • 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