MS Access and Perl. MS Access and Perl. Guest (visitor) (OP) 10 Apr 00 15:17 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 Donthivdonthi@ezode.com RE: MS Access and Perl. MikeLacey (MIS) 11 Apr 00 12:46 Hi Vijay,You have a few steps to go through.First of all. Do you have perl and perl DBI (the link to MS Access) installed?Mike Mike LaceyMike_Lacey@Cargill.Com Cargill's Corporate Web Site RE: MS Access and Perl. Guest (visitor) (OP) 11 Apr 00 12:52 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 Donthivdonthi@ezode.com RE: MS Access and Perl. dubotho (Programmer) 12 Apr 00 03:57 Hi VijaySo 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. AndyBo (MIS) 12 Apr 00 04:57 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.BYThis 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. njbebop (Programmer) 6 Jun 00 12:26 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. MikeLacey (MIS) 6 Jun 00 19:54 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? Mikemichael.email@example.com Cargill's Corporate Web SitePlease -- 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?"