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?

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.

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

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.