[Microsoft][ODBC SQL Server Driver]Timeout expired

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

[Microsoft][ODBC SQL Server Driver]Timeout expired

Author

Topic

srinivas.alwala
Starting Member

30 Posts

Posted - 2008-03-06 : 05:56:22

Hi,

I have tried updating the DSN configure option i.e. 30000 milliseconds.

But I am still facing the problem of Timeout Expired.

I am using sql server 2005 for daily importing data from Excel Dump Files into sql server table.
Everyday the database gets updated.
The Error mentioned in Subject normally gets once a month, due to daily updation of database whether each table structure gets changed like index, trigger, etc.

Kindly let me know how to resolve this error.

Regards,

Srinivas Alwala

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-06 : 13:41:42

How to resolve the error:

1. Write more efficient queries
2. Properly design your database
3. Add indexes to support your queries
4. Perform database maintenance such as ALTER INDEX and UPDATE STATS

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources