If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > [ODBC Access SQL Server Driver]Timeout expired (#0)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Feb 2006
Posts: 2
[ODBC Access SQL Server Driver]Timeout expired (#0)

I have an Access 2003 db with linked tables to views on SQL Server 2000. When I try to run a query with a date range of more then 1 day, I get the following error: "[ODBC Access SQL Server Driver]Timeout expired (#0)". I have altered my DSN Long Run time on the fourth page to 99999 and 0 ms and I still get the error after 60 sec... If I build the date range slowly, I can usually only see the error once or twice, but if I go for broke and list a year date range, I can never seem to get past the error. I have had my dba follow the log on to SQL Server and it appears the query continues to run even though Access has stopped. I am using Access as a Client Adhoc Query tool againest SQL Server.

The os is XP Pro.

This problem is un-acceptable to the user, can anyone suggest a solution?
Reply With Quote
  #2 (permalink)  
Old
Moderator
 
Join Date: Dec 2004
Location: Madison, WI
Posts: 3,925
Timeout

This may not solve your problem but in an MSAccess query, if you view the properties of the query, you can set the ODBC timeout to 0.
__________________
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Feb 2006
Posts: 2
In tools/options/?
Reply With Quote
  #4 (permalink)  
Old
Moderator
 
Join Date: Dec 2004
Location: Madison, WI
Posts: 3,925
Timeout

In the query design view, double-click somewhere on a blank area in the top part (where the tables are), or right click on a blank area in the top (if you right-click on a table and select properties, you'll see the properties of the table but once you click on a blank area in the top, you'll see the query properties). Look for the line ODBC Timeout.
__________________
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On