• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

Perl and Microsoft Access

Is it possible to read and write to a Microsoft Access database?  If so how can I find out how to do it?
0
donb1
Asked:
donb1
  • 4
  • 3
1 Solution
 
donb1Author Commented:
I would like to do it using perl 5.
0
 
b2piCommented:
Are you on a win32 machine?
0
 
donb1Author Commented:
I use phone link to an NT box

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
b2piCommented:
Is the machine on which you execute the code a win32 machine?  If it is, you can use the  Win32::ODBC module.  If not, you're either out of luck, or you can set up a perlserver on a Win32 machine which will do it for you.
0
 
donb1Author Commented:
b2pi

My server admin came back to me with the following answer:

The answer is, yes we are WindowsNT which is 32 bit.   They are
referring to a library module that contains code for accessing Access dB's using ODBC.  Anyway, we need to find this Perl library routine and load it on the server so that you can call it's routines.  If you find something, Email it to me and I'll load it on the server and send you the path.

Does this help?

0
 
b2piCommented:
1.) Determine if they're using a native build, or ActivePerl
2.) If it's activeperl make _really_ sure that it's a newer build (preferably 508)
3.) Get and install Win32::ODBC from http://www.roth.net/odbc/
4.) Learn how to use it at http://www.roth.net/odbc/odbc.html

(Sorry but the author apparently isn't using either CPAN or pod documentation)
0
 
donb1Author Commented:
Thanks - Looks to me like it is a lot easier to just use files in perl.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now