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

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	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 (2789 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 (2785 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 (2781 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 (2777 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

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

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