Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

getting the error "odbc sql server driver timeout expired" Expand / Collapse
Author
Message
Posted Tuesday, May 5, 2009 7:18 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 3, 2013 2:44 PM
Points: 60, Visits: 237
Hi ALl,
When i am trying to run the query from UI (to SQL) , getting the error "odbc sql server driver timeout expired".

Please provide me the reason for this issue and how to handle these issues.
Post #710159
Posted Tuesday, May 5, 2009 9:39 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 2:59 PM
Points: 473, Visits: 606
One reason could be the query you trying to execute takes a long time and the driver is timing out waiting for the response from the SQL Server. The default value is several minutes (I do not remember exactly - it was a while ago when I used ODBC) so if your query is executing quickly in Management Studio then maybe the UI timeout value was set to a much smaller value - check if your code is setting the timeout values.


---------------------------------------------
Nothing is impossible.
It is just a matter of time and money.
Post #710390
Posted Wednesday, May 6, 2009 2:30 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 19, 2013 8:47 AM
Points: 273, Visits: 441
I have seen the same problem here where some Access "applications" were used as front ends for the MSSQL tables. There is a timeout field that you can set. Don't make the same mistake we did and set it really high. Set it to 0 (my experience in Access) and it will disable time out.

What kind of UI is it?
Post #711554
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse