Re^4: How to connect MS Access Database?

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

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
[download]

all the three ini file is empty:(

Comment on Re^4: How to connect MS Access Database? Download Code

Replies are listed 'Best First'.
Re^5: How to connect MS Access Database? by tachyon-II (Chaplain) on Mar 28, 2008 at 05:54 UTC
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	[reply]

Replies are listed 'Best First'.

Re^5: How to connect MS Access Database?
by tachyon-II (Chaplain) on Mar 28, 2008 at 05:54 UTC

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

[reply]

In Section Seekers of Perl Wisdom