Hi David,
I coded the connection stuff a little different. I too was having
timeouts thrown back when the result sets were large. The same query
would take almost three minutes in a query window. So I set the
CommandTimeout to zero as described in the cpan doc. Looks like this for
me:
if($info->{user}) # this DSN requires username / pass | Oracle DSN work this
way
{
$dbh = DBI->connect( "dbi:ADO:$info->{'dsn'}",$info->{'user'},
$info->{'pass'}, "CommandTimeout=0" ) or $x = 1;
print "\t--->Use of SQL Server Authentication.\n";
}
else # this DSN uses OS Authentication
{
# print "ado connection\n";
$dbh = DBI->connect(
"dbi:ADO:$info->{'dsn'}","CommandTimeout=0" ) or
$x = 1;
print "\t--->Use of NT Authentication Connection.\n";
}
Anyhow, it looks like it is working !!!!
George
