ODBC Timeout

[scabral79]

I have a vendor client application installed on a local machine which uses an SQL ODBC connection to connect to SQL Server 2000.

I have the ability to run T-SQL commands from within the application. However, when i am executing a certaion stored proc that takes about 2 1/2 minutes to run from Query Analyzer, it times out after exactly 2 minutes from the application.

i get the following error:

Error: S1T00: [Microsoft][ODBC SQL Server Driver]Timeout Expired

does anyone know where the ODBC driver timeout setting are set? I believe mine is set to 120 seconds, but i need to increase it.

thanks
scott

 

[AlexCuse]

This would need to be handled in your application.

In ADO you can do it by setting the CommandTimeout property on your command objects. I am not sure about ODBC. What is your application written in?

Ignorance of certain subjects is a great part of wisdom