Page 250 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Unit 14: Application Development and Administration

Notes

The “Add Wizard” will walk you right through assigning a system ODBC name to the Access
database you setup. Notice that I made four of them: “Access”, “db1”, “Extropia”, and
“MyCompany”.

Putting it all together with a DBI-AwareCGI Script

I have prepared a little DBI script for us to walk through. You can copy this over to your system,
change the setup variables and it should run on your system as well. The code of this should all
be straight forward and you should have all read the Perl tutorials at Web Ware, so I won’t spend
much time documenting the code.

# First we identify the location of
# the Perl interpreter. You will need

# to change this line to reflect the
# location of Perl on your system.
#!c:\Perl\Perl5.00402\bin\perl.exe
# Next we will tell Perl that we are
# going to USE the DBI and CGI

# modules.
#
# We will use the CGI module mainly
# to handle incoming form data.

LOVELY PROFESSIONAL UNIVERSITY 243