microsoft odbc sql server driver timeout expired

Last Post 07 Apr 2008 12:41 PM by SQLUSA. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Markus_SQL
New Member
New Member

--
07 Apr 2008 07:56 AM
We have an app running on SQL 2000 SP4/ Win2003SP2 that once in a while gets microsoft odbc sql server driver timeout expired. In all of my Internet searches I have really found nothing. Anyone with any help would be appreciated.
SQLUSA
New Member
New Member

--
07 Apr 2008 10:16 AM
Check the timeout setting on the server and in the client software.

Also, it is possible that blocking is causing the timeout?

You can run SQL Server Profiler trace to check performance.

Are you indexes deteriorated?

Make sure that dynamic tables are reindexed every night with FILLFACTOR 70.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
Business Intelligence Workshop NYC SSAS, SSIS, SSRS - April 21-24: http://www.sqlusa.com/
SQLUSA
New Member
New Member

--
07 Apr 2008 12:41 PM
I can do that. "With the appropriate fill factor".

Sounds very diplomatical....
You are not authorized to post a reply.

Acceptable Use Policy