MS Access and Perl.

[Guest_imported]

I am trying to take in registration information from my users and insert it into a MS Access Database.<br>I am new to perl.<br>Can anybody tell me the exact procedure for writing a perl script.<br> <p>Vijay Donthi<br><a href=mailto:vdonthi@ezode.com>vdonthi@ezode.com</a><br><a href= > </a><br>

 

[MikeLacey]

Hi Vijay,<br><br>You have a few steps to go through.<br><br>First of all. Do you have perl and perl DBI (the link to MS Access) installed?<br><br>Mike <p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[Guest_imported]

Hi Mike,<br>&nbsp;What is perl DBI.<br>&nbsp;I do not find perl DBI in my perl folder.<br>&nbsp;Is there any site where I can download it from.<br>&nbsp;I am working in a Windows NT environment.<br>&nbsp;Awaiting your reply.<br>&nbsp;Vijay. <p>Vijay Donthi<br><a href=mailto:vdonthi@ezode.com>vdonthi@ezode.com</a><br><a href= > </a><br>

 

[dubotho]

Hi Vijay<br><br>So U don't know what the Dbi module is ? What a pity ...<br><br>First of all, you can download it from any good site about perl (<A HREF="

http://www.perl.com"

TARGET="_new">

http://www.perl.com</A>

for example)<br><br>Assuming You have installed Active Perl, launch an Ms Dos prompt and type ppm, then you simply enter &quot;install dbi&quot; and ppm (Perl Package Manager) should take care of the rest.<br><br>Since Ms Access supports ODBC, you have to install the dbd:dbc module. Under ppm enter &quot;install dbd-odbc&quot;.<br><br>That's all ...<br><br>DBI stands for DataBase Independent Interface, it is a module supplied for free with the normal Perl 5 distribution.<br><br>The DBI module is an useful tool because it abstracts away the need to learn&nbsp;&nbsp;how to communicate with every type of database.<br><br>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)<br><br>Thomas<br>

 

[AndyBo]

Just to add to what Thomas has said, the <A HREF="

http://www.perl.com"

TARGET="_new">

http://www.perl.com</A>

link will eventually lead you to CPAN - the Comprehensive Perl Archive Network.&nbsp;&nbsp;This is a world-wide set of mirrors all offering the same perl modules from local mirrors.<br><br>A full, very detailed, list of mirrors is available at <A HREF="

http://www.perl.com/CPAN-local/MIRRORED.BY"

TARGET="_new">

http://www.perl.com/CPAN-local/MIRRORED.BY</A><br><br>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.<br><br>Hope this helps.

 

[njbebop]

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...<br><br>test 3a = new() : [-1181] [] &quot;[Microsoft] [ODBC Microsoft Access Driver] could not find file '(unknown)'&quot;<br><br>I tried configuring the win 32 ODBC data sources and still get the message. what can be wrong?<br><br>Thanks<br>

 

[MikeLacey]

Hmmm...<br><br>I use DBI on Unix - not win yet.<br><br>what's the line in the script that's failing?<br><br>what DSN's have you got defined? can you use them from other programs? <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>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?"