What version of DBD::ADO are you using?
perl -MDBD::ADO -e 'print $DBD::ADO::$VERSION;'
Tom
On Wed, Feb 06, 2002 at 02:34:43PM +0100, jc plat wrote:
> I want to set the AutoCommit property when opening my database
> connection on a SQL server 7 on the same W2000 box.
> I'm using ActiveState Perl 5.6.1.
>
> I've tried the following:
>
> my $dbh = DBI->connect('DBI:ADO:absolut','sa','',{ AutoCommit => 0 })
> or die "Couldn't connect to database : " . DBI->errstr;
>
> which give me the error:
>
> Can't disable AutoCommit at C:/Perl/site/lib/DBI.pm line 433
>
> Did anyone know how to resolv that problem ?
>
> Then I also have trouble to use placeholders (?) in sql statement. Here is my
> code:
> $sth = $dbh->prepare("select * from Category where CategoryId=?");
> $sth->execute('1');
>
> and the error:
>
> DBD::ADO::st execute failed: Can't execute statement 'select * from Category
> where CategoryId=?': -2147217904: OLE exception from "Microsoft OLE DB
> Provider for ODBC Drivers":
>
> [Microsoft][ODBC SQL Server Driver]Champ COUNT incorrect
>
> Win32::OLE(0.1502) error 0x80040e10
> in METHOD/PROPERTYGET "Execute"
> -2147217904: at tmp.pl line 11.
>
>
> Thanks
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
