Solved

Does anyone know what causes this message - ODBC--call failed

Posted on 2007-03-22
5
615 Views
Last Modified: 2013-11-29
The full message is :
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine  
Interface]S1T00Timeout expired.  

I can stop the message occuring by following instructions given:
http://www.pervasive.com/kb/kb.asp?solid=00016461 

BUT what actually causes the delay ...

Is it that
1. the server is not quick enough
2. the drives are not quick enough
3. someone else is holding the record and the ODBC link is waiting to read the record and times out
4. anything else

Thanks
Paul


0
Comment
Question by:Zarbs
  • 2
  • 2
5 Comments
 
LVL 44

Accepted Solution

by:
GRayL earned 250 total points
ID: 18776488
http://www.dbforums.com/showthread.php?t=436735

Does the anwer by PepGonzales trigger anything?
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 18779421
I could be any number of those items, or it could be (as the link by Ray points out) that you're returning too large of a recordset.

Are you using bound forms? If you are, then your #3 could occur. If this becomes a common problem, you may need to move over to unbound forms, which would pretty much eliminate that scenario.
0
 

Author Comment

by:Zarbs
ID: 18791006
The record counts of the ODBC linked tables are:
INTRX = 5,653,099 records
INLOC =  12,044 records
The 3rd table generated by a query [520-0 Unique Itemkeys] contains 3,625 records

I am actually unsure how many records will be returned ... a rough guess would be about 150,000.

What is a "bound form"?  How do I move to unbound forms?
0
 
LVL 84
ID: 18791930
Assuming you're using an Access interface:

A bound form is one where you've set the .ControlSource of your controls (textboxes, combos, etc) to an underlying column in the form's Recordsource. To move to unbound, you'd need to (a) remove all .Controlsources from your controls and (b) handle all data manipulation via code. It can be a difficult process and if you're not familiar with it you might want to read up on it a bit.

Are you using a pass-through query for this? Or is this query built in Access as a "normal" query?
0
 

Author Comment

by:Zarbs
ID: 18847626
No, I am not using a pass through query for this.  Grayl has pointed out elsewhere that this is an option.

I guess the problem is I simply have too many records.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In this article you will learn how to create a free basic website on Bitbucket, a git service provider. Polymer creates dynamic HTML components, which allow more flexibility than static HTML. This tutorial uses Ubuntu Linux but can also be done on W…
The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now