Solved

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

Posted on 2007-03-22
5
620 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 85

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 85
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Before we dive into the marketing strategies involved with creating an effective homepage, it’s crucial that EE members know what a homepage is. In essence, a homepage is the introductory, or default page, of a website that typically highlights the …
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

717 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