The stupid question is the question not asked | |
PerlMonks |
Re^4: Setting CommandTimeoutby NetWallah (Canon) |
on May 06, 2016 at 00:47 UTC ( [id://1162322]=note: print w/replies, xml ) | Need Help?? |
I think you are running into some weirdness of the CommandTimeout property, as described in msdn. 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.
I suggest you create a command object, assign the Connecttimeout to the command, then execute the SQL from there. This is not an optical illusion, it just looks like one.
In Section
Seekers of Perl Wisdom
|
|