About.com has a fairly good tutorial on accessing databases, at http://perl.about.com/ Here's the code I would use to name an MS Access file in perl: use DBI; my $DSN = 'driver=Microsoft Access Driver (*.mdb);dbq=c:\temp\test_db.mdb'; my $dbh = DBI->connect("DBI:ODBC:$DSN","","") or die "Unable to open database:\n\n$DBI::errstr\n"; All of this can be found in the DBI and DBI::ODBC modules To: [EMAIL PROTECTED] cc: (bcc: Matt B. Grimaldi) Date: 03/13/2002 05:08 AM From: [EMAIL PROTECTED] Subject: Database access and automated emails with Active Perl Hello there, I'm Rafferty, a student from De La Salle University, Philippines. We are Active Perl, for our project in creating an e-commerce website. I'm new to Perl, so I asked our school about some things and I was told to visit ActiveState.com and ask for support instead. Hope you'll take the time to reply and help me. Our project is not that big so we are only using Microsoft Access for our database system. However, we don't know how to connect to the database using perl. Do we need to set up an ODBC configuration? If so.. then, do we have to ask our school for such a configuration? Because, from what I know, the ODBC configuration is needed to be set up in the control panel (if using a MS Windows Operating System) So, to avoid the hassle, is there a way that we can simply tell, through the code, that we want to use this specific database file which we uploaded on the server. Also, in our project, we will be allowing our users to register online, and then, a confirmation e-mail will be sent to the user. So how are we to create this automated e-mailing system? Your response is greatly appreciated. Yours truly, Rafferty Uy DLSU - Computer Science Student (See attached file: C.htm) *******************Internet Email Confidentiality Footer******************* Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of my firm shall be understood as neither given nor endorsed by it.
|
Hello there,
I'm Rafferty, a student
from De La Salle University, Philippines. We are Active Perl, for our project in
creating an e-commerce website. I'm new to Perl, so I asked our school about
some things and I was told to visit ActiveState.com and ask for support
instead. Hope you'll take the time to reply and help me.
Our project is not that big so
we are only using Microsoft Access for our database system. However, we don't
know how to connect to the database using perl. Do we need to set up an ODBC
configuration? If so.. then, do we have to ask our school for such a
configuration? Because, from what I know, the ODBC configuration is needed to be
set up in the control panel (if using a MS Windows Operating System) So, to
avoid the hassle, is there a way that we can simply tell, through the code, that
we want to use this specific database file which we uploaded on the
server.
Also, in our project, we will be
allowing our users to register online, and then, a confirmation e-mail will be
sent to the user. So how are we to create this automated e-mailing
system?
Your response is greatly
appreciated.
Yours truly,
Rafferty Uy
DLSU - Computer Science
Student |
