Re^3: Setting CommandTimeout

I meant to say

$Conn->CommandTimeout(120)

Didnt give a compile error. But it didn't set the commandtimeout value either.

Comment on Re^3: Setting CommandTimeout Download Code

Replies are listed 'Best First'.
Re^4: Setting CommandTimeout by NetWallah (Canon) on May 06, 2016 at 00:47 UTC
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. See this VBA discussion of the failure of CommandTiemout. This is not an optical illusion, it just looks like one.	[reply]

Replies are listed 'Best First'.

Re^4: Setting CommandTimeout
by NetWallah (Canon) on May 06, 2016 at 00:47 UTC

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.
See this VBA discussion of the failure of CommandTiemout.

This is not an optical illusion, it just looks like one.

[reply]