Re^2: MS Access database problem

I am ASTOUNDED

to learn that EVERY page I found led me to believe you could simply access it by the filename. Believe it or not, I searched high and low prior to posting here, and I never saw a page even reference HOW to open a MS Access database by it's DSN rather than it's name...

Needless to say..

That worked!!

A huge thank you

..oh, and no, the space before (*.mdb) didn't matter as doesn't capitalization on DBI, etc.. for those searching these forums later.

Comment on Re^2: MS Access database problem

Replies are listed 'Best First'.
Re^3: MS Access database problem by tachyon-II (Chaplain) on Dec 01, 2007 at 04:16 UTC
Actually having just read the pod for DBD::ODBC they have introduced direct access to mdb files since last I looked (6 years ago more or less :-). I think your original code would have worked if you had specified the full path to the testdb.mdb file. See DBD-ODBC/ODBC.pm#Connect_without_DSN Anyway glad you got it working. As noted in the DBD::ODBC pod if you use the DSN method that worked for you then you need to make it a system DSN, not a user DSN.	[reply]

Replies are listed 'Best First'.

Re^3: MS Access database problem
by tachyon-II (Chaplain) on Dec 01, 2007 at 04:16 UTC

Actually having just read the pod for DBD::ODBC they have introduced direct access to mdb files since last I looked (6 years ago more or less :-). I think your original code would have worked if you had specified the full path to the testdb.mdb file. See DBD-ODBC/ODBC.pm#Connect_without_DSN

Anyway glad you got it working. As noted in the DBD::ODBC pod if you use the DSN method that worked for you then you need to make it a system DSN, not a user DSN.

[reply]