ODBC Connection Timeout

[agoeddeke]

Hello,

I am searching for a connection string attribute that will shorten the default timeout when connecting to SQL Server. I am using Visual Foxpro as my client and I'm trying to connect to SQL over a DSN-less connection. The default timeout seems to be 15 seconds and I'd like to shorten it to around 5.

Thanks,
Andy

 

[adroit]

Setthe connectiontimeout property of the connection to 5 seconds.
e.g objConnection.ConnectionTimeout=5

 

[agoeddeke]

adroit,

That works fine when connecting using ADO, but I am using a DSN-less ODBC connection.

Andy

 

[andyrice]

I use Visual FoxPro.
Try the SQLSETPROP( ) function.
I'm not connected to SQL Server, so you'll have to test this.

Andy Rice
San Diego, CA

 

[SonOfEmidec1100]

I know nothing about FoxPro but theres a property dbengine.LoginTimeout, and to shorten each connection timeout once you have opened the database set MyDatabase.QueryTimeout

Maybe these comments will help.

 

[agoeddeke]

Thanks Guys,

SQLSETPROP has both a ConnectionTimeout and QueryTimeout setting. I'll try playing with both.

Andy