On Wed, Jun 06, 2001 at 11:17:25AM +0100, [EMAIL PROTECTED] wrote:
> 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
I haven't exported these constants from the module for the calling
application. I'll add it to the To-Do list.
> 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 thought I had support for inheriting the CommandTimeout from the
Connection object, but reviewing the code, it doesn't.
> 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.
Great! Send me a patch (prefer diff -c) and if possible, a "test(s)" for
the change.
> 3. Is there a reason that Stream support should not be added to ADO.pm. Has
> anyone experimented with this
The short answer: No. Not I. Please feel free and encouraged to do so.
The long answer:
When I did most of my development on DBD::ADO, I worked in an Windows NT
environment with HP large database servers. All the desktops, web
servers, and some database servers where Windows based. ADO was prefect
for integrating the numerous data sources.
Since August 2000, I changed positions to a Linux and Sun based
environment with very little interaction with Windows. Occasionally I
still need a Windows data source, but not day to day.
Additionally, I've an older version of VC++ (5.0 sp3), which I finding
doesn't work with the newer version of Activestate Perl (for building
modules either not supplied by PPM or installing more current versions).
I haven't shelled out the money for a newer compiler, yet.
What this means is development time (for me) on DBD::ADO is very limited
now. If you've features or changes, please send me patches, documents,
and/or tests.
Thomas
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
