reduce timeout when database unavailable

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

It's ConnectionTimeout, in the connection object.

See this page for reference:

-- Gianluca Sartori

andrew.davies Grasshopper Points: 16 More actions · Answer 2

thanks, but that doesn't seem to affect the length of timeout period. Still 20s even if I set as low as 5s

e.g. ConnectionTimeout = 5

any other suggestions?

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

Are you using a command object or opening the recordset with connection.execute?

If you are using a command object, check the connection timeout property there.

-- Gianluca Sartori