|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Catastrophic Error |
| Author |
Message |
|
|
| Posted : 2007-08-22 08:03:00 |
| Hello. I wish to know if users connecting to QB data using openquery architecture encounter problems when running queries? Periodically I receive a message "Provider has encountered a catastrophic error". The query will fail when this happens. I must then restart the SQL service and run query again. We have linked our QB data source as a linked server in SQL 2005. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-08-22 10:36:52 |
Could you please provide a little more detail?
How does this occur?
How many users are using QuickBooks?
How many users are using QODBC?
How many users are using the linked tables?
When? After 1 hour, 3 days, 2 months? |
|
|
|
|
|
| Posted : 2007-08-23 00:28:54 |
This occurs when we are inserting invoice lines & headers into QB from SQL. When we run the queries, we have approx 5-10 concurrent users of QB but I'm the only developers using QODBC. The query will run for 30 seconds then report the error. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-08-23 19:24:27 |
| Do you mean that things will stop working after only 30 seconds? How many invoice lines and headers are written before this happens? |
|
|
|
|