Well, err, no. Don't use DBD::ODBC...calling DBI->connect will do the right thing.
Jeff > > > Hi Angela, > > You have to install DBD-ODBC: > > ppm install DBD-ODBC > > and add: > > use DBD::ODBC; > > in your script. > > Paul. > > Angela Chan wrote: > > > After I install DBI using PPM, I got the following message when > I run simple > > script, is that means I need to install the other module beside > DBI? if so, > > where I could download that module? Thanks > > > > install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC (@INC > > contains: C:/Perl/lib C:/Perl/site/lib .) at (eval 1) line 3. > Perhaps the > > DBD:: ODBC perl module hasn't been fully installed, or perhaps the > > capitalisation of 'ODBC' isn't right. Available drivers: > ExampleP, Proxy. > > > > the simple script that I ran: > > #C:/perl/folder/in/windows > > ######################################### > > # > > # This script is connecting ODBC > > ########################################## > > # > > > > #use strict; > > use DBI; > > > > my $dbh = DBI->connect("dbi:ODBC:TAS_database") > > or die "Can't connect to ODBC database"; > > > > exit; > >