Re: How to connect MS Access Database?

Try this:

my $db = "/home/test/a.mdb";
my $DSN = "driver=Microsoft Access Driver (*.mdb);dbq=$db";
my $dbh = DBI->connect("dbi:ODBC:$DSN",'','') or 
              die "Can't connect to $DSN $DBI::errstr\n";
[download]

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

Replies are listed 'Best First'.
Re^2: How to connect MS Access Database? by pysome (Scribe) on Mar 28, 2008 at 04:14 UTC
Thanks. But the error msg is same as before.:-(	[reply]
Re^3: How to connect MS Access Database? by tachyon-II (Chaplain) on Mar 28, 2008 at 04:34 UTC
Get a shell and report back what these commands say (dont type the $ ;-) `$ odbcinst -q -d $ odbcinst -j` [download]	[reply] [d/l]
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` [download] all the three ini file is empty:(	[reply] [d/l]
Re^5: How to connect MS Access Database? by tachyon-II (Chaplain) on Mar 28, 2008 at 05:54 UTC
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.	[reply]


Welcome to the Monastery
	PerlMonks