Hello all. I have some questions about using the ADO driver with M$ SQL
Server.
1. Does this driver support transactions? When I try to connect like
so:
my $dbh = DBI->connect("dbi:ADO:$DSN",'','',{RaiseError => 1, AutoCommit
=> 0}) or die "$DBI::errstr\n";
I get the message: "Can't disable AutoCommit at c:/Perl/site/lib/DBI.pm
.... "
But it works fine with AutoCommit => 1.
2. Why would I have trouble with binding?
If I prepare my query like this:
$query = "select product from orders where id=?";
my $cp = $tdbh->prepare($query);
$cp->execute($id) || print $tdbh->errstr;
my ($product) = $cp->fetchrow_array;
I get the error: "No value given for one or more required parameters."
But if I prepare it like this:
$query = "select product from orders where id=$id";
my $cp = $tdbh->prepare($query);
$cp->execute() || print $tdbh->errstr;
my ($product) = $cp->fetchrow_array;
I get a value.
I've also tried using the bind_param method, to no avail. Could this be
a problem with the ADO driver? Has anyone else had this problem?
Joel Gwynn
Variable Data
Spire
617 832-1957
