×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ODBC Call Failed (Timeout) in Access

ODBC Call Failed (Timeout) in Access

ODBC Call Failed (Timeout) in Access

(OP)
From SQL Server 2005, receiving intermittant (very unpredictable) timeouts.

If the SQLSERVERAGENT service blows up and scheduled maintenance doesn't run for a week or two, we've seen it get VERY bad. As long as I make sure that's running to do the nightly cleanup, it's better, but not fixed.

The SQL server logs show nothing in Enterprise Manager, nor does Event Manager on the server. I'm pretty well stumped. Everything's working as it should, except users are sitting for disproportionately long periods of time (I presume the 30 seconds needed for a timeout to occurr) and then being shown the message -- on items that should take half a second to load (combo boxes and such).

I've seen references to all kinds of things but none of them have lead anywhere. The problem has persisted across two different servers, using various versions of Access clients, and can go for two weeks without appearing or happen 30 times in one day. Help would be very much appreciated.

RE: ODBC Call Failed (Timeout) in Access

We get these a lot when views or sp's fail when called from Access. Don't know if that's your case or not...

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

RE: ODBC Call Failed (Timeout) in Access

(OP)
Nah, not a query failure. The queries work 99% of the time. Case in point, we've had three people doing data entry all day and haven't had one tiny problem since before noon. The problems pop up at random places, but all commonly used. Combo boxes for selecting records to navigate to, closing forms, updating records.... You name it. Very aggrivating.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close