Home: Perl Programming Help: Win32 Programming Help:
Is there a...DBD for MS ACCESS; direct access



S_Shrum
User

Sep 30, 2001, 1:36 AM


Views: 7758
Is there a...DBD for MS ACCESS; direct access

This may be more of a general platform question but here it goes:

I am using the DBI and DBD:AnyData just fine. The issue I have is that I would like to open MS Access database files in a DSN-less way (i.e.: directly). I have looked around and have not found any talk about a DSN-less Access DBD.

Does one exist? If so, under what platforms will it work? If so where can I get it?

TIA

Sean Shrum
sean@shrum.net
www.shrum.net


Kanji
User

Sep 30, 2001, 5:46 PM


Views: 7754
Re: Is there a...DBD for MS ACCESS; direct access

DBD::ODBC on Windows.



S_Shrum
User

Oct 1, 2001, 5:21 PM


Views: 7750
Re: Is there a...DBD for MS ACCESS; direct access

Would this also work under non-Windows based networks (specifically FreeBSD and/or Linux).

Sean Shrum
sean@shrum.net
www.shrum.net


Kanji
User

Oct 5, 2001, 8:27 AM


Views: 7746
Re: Is there a...DBD for MS ACCESS; direct access

Not easily.

Honestly, you'd be better of exporting the data from your .mdb to, say, CSV or XML and then use those flatfiles as is (DBD::AnyData, DBD::CSV, DBD:xSV, etc)or as data to feed into a SQL db running on your target OS.

Another possibility if you have MySQL, PostgreSQL, Oracle or any other db that has Windows ODBC drivers available, is to have your copy of Access use a DSN that points directly to the db on the non-Windows OS.

With MySQL, you'll want to use either MyODBC (ships with MySQL for Win32) or AccessMySQL