ODBC driver and GUI

pabloj
2002-08-23
2013-05-01
  • pabloj

    pabloj - 2002-08-23

    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!)

     
    • Antonello Parente

      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

       

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks