Hi all I have a few questions that I have not seen anything in the archives
for. I have ADO2.1 installed on DBI 1.16
1. dbi:ADO supports setting Isolation Level but only as a number. Is there a
reason that it does not seem to use the ado_const's, eg adXactBrowse
2.dbi:ADO supports setting Connectiontimeout and CommandTimeout in the
connection string but I have discovered that ADO does not let a command
inherit its connections Command and Connection timeout values
see the following (also quoted below)
http://msdn.microsoft.com/library/psdk/dasdk/mdap4wc4.htm
"The CommandTimeout setting on a Connection object has no effect on the
CommandTimeout setting on a Command object on the same Connection; that is,
the Command object's CommandTimeout property does not inherit the value of
the Connection object's CommandTimeout value." </quote>
the upshot of which was a long query (over 9 minutes) was failing with a
timeout.
I have made a addition to my copy of ado.pm to add this to the %attr that
you can pass through on a prepare, and it seems to work.
3. Is there a reason that Stream support should not be added to ADO.pm. Has
anyone experimented with this
regards
Tim Wilson
------------------------------------------------------------------------
For more information about Barclays Capital, please
visit our web site at http://www.barcap.com.
Internet communications are not secure and therefore the Barclays
Group does not accept legal responsibility for the contents of this
message. Although the Barclays Group operates anti-virus programmes,
it does not accept responsibility for any damage whatsoever that is
caused by viruses being passed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of the
Barclays Group. Replies to this email may be monitored by the Barclays
Group for operational or business reasons.
------------------------------------------------------------------------
