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: DBI:
Create an MS Access file using DBI

 



Hanz
New User

Jul 25, 2008, 5:50 AM

Post #1 of 2 (3568 views)
Create an MS Access file using DBI Can't Post

hi,

I am trying to create an MS Access file using the perl DBI but I am not sure how to start. I use SuSE Linux and I have the DBI module installed. Can someone help?

Hanz,


(This post was edited by Hanz on Jul 25, 2008, 6:49 AM)


1arryb
User

Feb 27, 2009, 1:14 PM

Post #2 of 2 (2626 views)
Re: [Hanz] Create an MS Access file using DBI [In reply to] Can't Post

Hi Hanz,

I have never done this. So, take my advice for what it's worth. Nevertheless, from my reading, I believe it is possible to do what you want; however, you won't be able to go directly DBI to access UNLESS you move your perl client over to a windows box: Access doesn't run on Linux. Otherwise, you'll have to go through ODBC to get remote access to Access.

For the Linux side, you'll need: Perl, DBI and DBD::ODBC

For the Windows side, you'll need an MS Access odbc driver. I Googled around and it seems like they are out there, esp. for windows server.

Then, you need to configure odbc on your access server.

Once that's done, DBI from your linux client as usual.

Sounds like a royal pain. Unless you absolutely need the ability to update a live copy of the Access db, why not just dump it to a csv file and loading it into your favorite db on linux?

Good luck,

Larry


Good luck,

Larry

 
 


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

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