Re: DBD::ADO and CommandTimeout
From: PerlDiscuss - Perl Newsgroups and mailing lists (gEckenro_at_BellSouth.net)
Date: 09/26/04
- Previous message: Ron Reidy: "RE: Faster Inserting Code"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 25 Sep 2004 23:00:41 -0000 To: dbi-users@perl.org
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
- Previous message: Ron Reidy: "RE: Faster Inserting Code"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
