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!
  • Students Click Here

*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





I have a VB.net application with 9 forms. They all pull Data from multiple Pervasive Databases on the Same Server using PCC V10.
I'm Using the ODBC.
When Retrieving all data from one table I get a time out error.
I should also tell you that all the databases except the one that contains the table causing the error were not created by me, the other DB belong from another application.
The Only difference the tables I created has an indexed Column and the tables from the other DB don't.
This is error I'm receiving.

RE: S1T00Timeout

Does the table have any indexes? What type of query are you running? Does it have any restrictions (WHERE clauses)?
One thing you can try is to change the Command and Connection Timeout options. The default is 30 seconds. Changing the option to 0 will disable it and let the query run to completion regardless of how long it takes.

Certified Pervasive Developer
Certified Pervasive Technician

RE: S1T00Timeout

Thanks Mirtheil for your reply.
Yes it has one column index, and yes it has many restrictions.
Can the timeout be altered with code if it can how can I do it.

here is the query I'm using
SELECT log.OE,log.Link,log.userini,log.process_Value,log.process,log.Log_Date,Log_time,live.ORDD_Description,
SOH.CUST_PO_NO ,wb.Mask as Lot,log.department,w.ORDfrmServ,w.reqdaterev
CWLIVE.Sales_Order_Header AS SOH
WHERE Live.BV_GUID=log.Link AND wb.Field_Name='Lot' and wb.ORD_ORDER_NO=Log.OE AND w.ord_Order_NO=log.OE AND SOH.Number=LOG.OE
ORDER BY Department

RE: S1T00Timeout

What field is the index on? Ideally you would at least have an index on the Live.BV_GUID and log.Link fields.

How long does the query take using Pervasive Control Center executing into "Text"?

The connection and command timeouts are properties of the Connection and Command objects you are using in code (PsqlConnection / PsqlCommand, OdbcConnection / OdbcCommand, etc).

Certified Pervasive Developer
Certified Pervasive Technician

RE: S1T00Timeout

The only table that has Indexes is the Log table and it isn't in the query.
Regarding the time it takes for PCC to execute the query into text I will reply tomorrow when I try.

RE: S1T00Timeout

PCC takes 2min to exe the query into text.
The application Times Out at 31sec.

RE: S1T00Timeout

It's the COnnection or COmmand timeout. You need to set those in your code to something either higher or 0. I would start with the Command Timeout and then the COnnection Timeout.

Certified Pervasive Developer
Certified Pervasive Technician

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!

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