http://qs321.pair.com?node_id=676906


in reply to Re^2: How to connect MS Access Database?
in thread How to connect MS Access Database?

Get a shell and report back what these commands say (dont type the $ ;-)

$ odbcinst -q -d $ odbcinst -j

Replies are listed 'Best First'.
Re^4: How to connect MS Access Database?
by pysome (Scribe) on Mar 28, 2008 at 05:18 UTC
    The Output:
    $ odbcinst -q -d odbcinst: SQLGetPrivateProfileString failed with . <br > $ odbcinst -j unixODBC 2.2.12 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini USER DATA SOURCES..: /home/test/.odbc.ini
    all the three ini file is empty:(

      Ok. The -q -d options should have given you a list of supported databases. As it choked you now know your unixODBC-2.2.12,mdbtools-0.6pre1 install is broken. Probably because it is pre-release. Obviously you need to get this reinstalled and working. Probably best to go with a known stable release FWIW.

      There is a tutorial here which details why you are getting the error message you are (it is probably not the "right" error message due to a 32 char limit).

      Good luck

      Cheers

      tachyon

Re^4: How to connect MS Access Database?
by Anonymous Monk on May 05, 2011 at 17:51 UTC
    sh.exe": odbcinst: command not found sh.exe": odbcinst: command not found am gettign above. please help me to connecr access DB.