>Hi!
>
>I am new to Perl CGI programming and have been researching what is
>needed to write a scipt to connect to an Access DB. What I have noticed
>so far is the recommended perl modules are DBD::ODBC and/or Win32::ODBC
>- is this correct? The only complication I can see arising is that the
>module I select would need to work on both Win 2000 and UNIX platforms,
>so would the DBD::ODBC module be the choice?

Yes, DBD::ODBC is probably your best choice, but more importantly you need
DBI first!

you would then do something like:

use strict;
use DBI;

my $datasource = "DBD:ODBC:MY_DSN_NAME";

# try to connect
my $dbh = DBI->connect($datasource) or die "Couldn't connect to
$datasource: " . $DBI->errstr;

# do some queries

# close the connection
$dbh->disconnect;


>Also, how do I go about finding out what modules are already on my
>computer - I am not certain if how I went about my search was correct?
>In the command prompt I entered:
>
>find `perl -e `print "@INC"'` -name `*.pm' -print
>
>The response was:
>File not found - `*.pm'

This one someone else may have a better idea for, if you are on win32 you
can use PPM to query installed packages, on *nix I believe the CPAN module
in the shell mode (which ppm is basically a copy of) can do the same thing.

Good luck!

Chuck

_______________________________________________
Perl-Win32-Web mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web

Reply via email to