I have ActiveState Win32perl running. I installed fresh DBI, DBD, etc. from
perl ppm.pl> prompt. But prepare( ) doesn't work (see below). perldoc
DBI/DBD/DBI-FAQ are not useful since they assume it works. Any hints?
Art
www.mp3.com/ArthurSulit
Classical Artist
recently charted above Madonna
-----Original Message-----
From: Art Sulit [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 20, 2001 1:51 PM
To: [EMAIL PROTECTED]
Subject: POSSIBLE BUG IN YOUR DBI INSTALL MODULE: DBI "prepare" no work
Hello,
THERE IS A POSSIBLE BUG IN YOUR DBI INSTALL MODULES: prepare.al NOT PRESENT
As you know, prepare() is a CRITICAL SQL function, and needs to work.
Here's one example of many where mine does not work:
I'm using DBI, DBI:ODBC, DBD::ODBC for Win32 to talk to an MS Access
database called InventoryControl1. I set up proper DSN's, etc. and those
work. However, my $sth ... prepare doesn't work. Errormsg is:
"Can't locate auto/DBI/prepare.al in @INC (@INC contains C:/Perl/lib
C:/Perl/site/lib
.) at dbi.pl line 29"
CREATE TABLE, however, works, so I know I have a successful database
connection. why doesn't prepare() work????
Art Sulit (simple code below)
650-330-8050
---------------------------------------------------------
#!/usr/local/bin/perl5 -w
use DBI;
use DBI::DBD;
use DBD::ODBC;
# use strict;
$db = "InventoryControl1"; # "InventoryControl1"; "ContactManagement1"
$user = "namie";
$password = "secretie";
$dbd = "ODBC"; # Microsoft Access Driver (*.mdb)
$dbhandle = DBI->connect($db, $user, $password, $dbd);
die "Error connecting to database, $DBI::errstr\n" if (!$dbhandle);
$dbhandle->do("CREATE TABLE losers3 (uid INT, login CHAR(8))")
or die "doing: ", $dbhandle->errstr;
$sth = DBI->prepare("SELECT * FROM Categories");
$sth->execute or die "executing: ", $sth->errstr;
$sth->finish;
$dbhandle->disconnect;
exit;
_______________________
Art Sulit <[EMAIL PROTECTED]>
Classical Archives, LLC
Phone: 650-330-8050
Visit the Classical Archives
at http://www.prs.net/
---
Listar v1.0.0 - job execution complete.
