Try this, it worked for me a couple of weeks ago:
my $dbh = DBI->connect("dbi:ADO:Provider=SQLOLEDB;...");
# do appropriate error checking
$dbh->{ado_commandtimeout} = 0; # turn off timeout
HTH,
Dave
On Sep 15, [EMAIL PROTECTED] scribed:
> Hello,
>
> Is there way to set timeout in DBD::ODBC?
> I'm trying to make a script updating SQL server.
>
> I hear our SQL server is set 10 minutes as timeout (default).
> And also I hear ADO has 30 secomd default time & can be
> changed with some property.
> Not knowing much about timeout on ODBC.
>
> Any documerntation in DBI or DBD::ODBC?
> (failing finding out by google....)
>
> Regards,
> Hirosi Taguti
> [EMAIL PROTECTED]
>
>
>
>
>
>
>
