×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

MS Access and Perl.

MS Access and Perl.

MS Access and Perl.

(OP)
I am trying to take in registration information from my users and insert it into a MS Access Database.
I am new to perl.
Can anybody tell me the exact procedure for writing a perl script.

Vijay Donthi
vdonthi@ezode.com

RE: MS Access and Perl.

(OP)
Hi Mike,
 What is perl DBI.
 I do not find perl DBI in my perl folder.
 Is there any site where I can download it from.
 I am working in a Windows NT environment.
 Awaiting your reply.
 Vijay.

Vijay Donthi
vdonthi@ezode.com

RE: MS Access and Perl.

Hi Vijay

So U don't know what the Dbi module is ? What a pity ...

First of all, you can download it from any good site about perl (www.perl.com for example)

Assuming You have installed Active Perl, launch an Ms Dos prompt and type ppm, then you simply enter "install dbi" and ppm (Perl Package Manager) should take care of the rest.

Since Ms Access supports ODBC, you have to install the dbd::odbc module. Under ppm enter "install dbd-odbc".

That's all ...

DBI stands for DataBase Independent Interface, it is a module supplied for free with the normal Perl 5 distribution.

The DBI module is an useful tool because it abstracts away the need to learn  how to communicate with every type of database.

What the DBI module module does for You is to provide a single interface to send SQL commands to any proprietary database. (it requires an extensive library of DBD modules, DBD stands for DataBase Dependent, which provide the code that hooks up DBI to a proprietary database driver)

Thomas

RE: MS Access and Perl.

Just to add to what Thomas has said, the www.perl.com link will eventually lead you to CPAN - the Comprehensive Perl Archive Network.  This is a world-wide set of mirrors all offering the same perl modules from local mirrors.

A full, very detailed, list of mirrors is available at http://www.perl.com/CPAN-local/MIRRORED.BY

This can be useful if you want to manually download a module, but in mt experience the ppm command mentioned by Thomas has worked very well.

Hope this helps.

RE: MS Access and Perl.

I have tried to do the above but when I try using test.pl with the odbctest.mdb access database provded with the DBD, I get this error message...

test 3a = new() : [-1181] [] "[Microsoft] [ODBC Microsoft Access Driver] could not find file '(unknown)'"

I tried configuring the win 32 ODBC data sources and still get the message. what can be wrong?

Thanks

RE: MS Access and Perl.

Hmmm...

I use DBI on Unix - not win yet.

what's the line in the script that's failing?

what DSN's have you got defined? can you use them from other programs?

Mike
michael.j.lacey@ntlworld.com
Cargill's Corporate Web Site
Please -- Don't send me email questions without posting them in Tek-Tips as well. Better yet -- Post the question in Tek-Tips and send me a note saying "Have a look at so-and-so in the thingy forum would you?"

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close