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
|
|
I have a 300mb QB file on a machine with 500 mb ram and QODBC hangs |
Author |
Message |
|
Posted : 2006-09-23 12:02:12 |
I try to get a month worth of transaction data in access and the system hangs. Will more memory help? IS there a size limit? Additionally, are there any entity diagrams to understand the relationship between tables. I want to replicate the transaction detail query in SQL |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-23 17:43:51 |
You need to allow the QODBC optimizer to optimizer the large company file first. At the DOS Command prompt run: QODBCFUL.EXE, passing the DSN for the company file you want to optimizer. The default DSN to use is QuickBooks Data as shown here:
This will create all the optimized tables and may take a few hours. Once that's done you can query the company file.
See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more information. |
|
|
|
|
Posted : 2006-09-23 23:43:26 |
I am using the QODBC that ships with QB Enterprise. QODBCFUL.EXE does not appear to be installed??? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-25 00:00:04 |
|
|
|
|