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
|
|
Downgrading QODBC |
Author |
Message |
|
Posted : 2008-08-05 00:45:40 |
I have just moved a system onto a new PC. I used the old QB and old app. but the latest version of QODBC.
However, the latest version doesn't work on this system (QB 2004 and a custom VB6 app), so I have to downgrade to QODBC V5.
Can I just install V5 over the top of V8? Or do I need to uninstall and reinstall?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-05 07:48:29 |
We no longer support QODBC v5 as the registration system was changed in QODBC v6, 7 and 8 to allow for easier activation and deactivation. QODBC ships with VB Demo which is itself a VB6 app that continues to work with every version of QODBC and every version of QuickBooks and every version of QuickBooks in the world.
So the latest version does work with VB6 apps. |
|
|
|
|
Posted : 2008-08-05 23:35:29 |
Well, yes, it works, but 45 seconds to read the first record in the recordset is barely working.
I don't mean to be offensive, but the demo is a very simple program, while a normal app exercises a lot more fuctionality.
I'll try V6 and see what happens.
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-06 09:39:17 |
When a query is executed, QODBC has to connect to QuickBooks, establish the security settings, then compare the last modified record in the optimized table table against the last modified record for the table in QuickBooks via a XML request, then update sync any new records in the optimized file via another XML request and then execute the query against the optimized table. So getting the first rowset is a big task.
QODBC v6, v7 and v8 all have the QODBC optimizer which in itself is a SQLite Server Engine that resides on the computer running QODBC. Rapid response queries can be executed by calling the optimized table directly using the NOSYNC tag like this:
Select Name from Customer NOSYNC
See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more.
|
|
|
|
|