CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

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

Post #1 of 4 (4118 views)
Is there a...DBD for MS ACCESS; direct access Can't Post

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

Post #2 of 4 (4114 views)
Re: Is there a...DBD for MS ACCESS; direct access [In reply to] Can't Post

DBD::ODBC on Windows.



S_Shrum
User

Oct 1, 2001, 5:21 PM

Post #3 of 4 (4110 views)
Re: Is there a...DBD for MS ACCESS; direct access [In reply to] Can't Post

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

Post #4 of 4 (4106 views)
Re: Is there a...DBD for MS ACCESS; direct access [In reply to] Can't Post

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


 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives