You are are missing the DBD driver for ODBC. What's missing from your message is what Perl you are using. I'll presume that it is ActiveState Perl. I'll also presume that you used the PPM tool to install DBI from an ActiveState repository. If true, the solution is to use PPM to install DBD::ODBC.
I've installed DBD::ODBC on an XP and have successfully accessed an MSDE server. (MSDE is the free "mini-me" version of the MS SQL server.) -----Original Message----- From: Matt [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 1:25 PM To: [email protected] Subject: Can not get DBI to work on a windows XP machine I have two computers one a Windows XP computer and the other a Windows 2003 server. I am trying to write a script that will connect to the MS SQL DB on the Windows 2003 server but I am having problems running it on the Windows XP computer. It works find on the Windows 2003 computer. The error I get on the XP computer is this: install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at (eval 4) line 3. Perhaps the DBD::ODBC perl module hasn't been fully installed, or perhaps the capitalisation of 'ODBC' isn't right. Available drivers: DBM, ExampleP, File, Proxy, Sponge. at I:\Final Fantasy Site Stuff\image.pl line 7 This is my perl code: #!user/local/bin/perl -w use strict; use DBI; use GD; my ($dir_path, @images, $image, $srcimage, $myobject, $width, $height, $subset, $alt, $sth, $dbh, $table); $dbh = DBI -> connect ('dbi:ODBC:images', 'uid', 'pass') or die "Could not open the database: $DBI::errstr;"; $dir_path = 'I:/Final Fantasy Site Stuff/FFXI images/'; $subset = 'elvaan'; $table = 'ffxi'; $alt = ''; opendir(DIR, "$dir_path/$subset"); @images = grep {/\.jpg$|\.gif$/} readdir(DIR); closedir(DIR); foreach $image (@images){ if ($dir_path/$image =~ /.gif$/i) {$srcimage = GD::Image -> newFromGif($myobject);} if ($dir_path/$image =~ /.jpg$/i) {$srcimage = GD::Image -> newFromJpeg($myobject);} ($width, $height) = $srcimage -> getBounds(); $sth = $dbh -> prepare (qq~insert into $table (image, subset, height, width, alt) values ($image, $subset, $height, $width, $alt)~) or die "Could not prepare statement: $DBI::errstr"; $sth -> execute() or die "Could not execute SQL statment: $DBI::errstr";} I tryed reading though the info at http://dbi.perl.org/docs/ to see if anything was there that could help me but all the links timeout on me. I have tryed reinstalling the DBI module on my XP computer but still get the error. Can anyone help me fix this? Thank you, Matt Verstraete
Brian Campbell (E-mail).vcf
Description: Binary data
