I am testing the ODBC driver.  The "Test Connection to Quickbooks" in the the ODBC connection runs successfully.  But when I use the VB Demo applicaiton, the sql queries are returning no data.  The company file I am using has data in it for the tables I am querying. 

Open your company file in QuickBooks and then in VB Demo try temporarily bypassing your optimizer settings and extract the latest information directly by using the unoptimized tag after the table name like this to your queries:

select * from InvoiceLine unoptimized where TxnDate >= {d'2007-03-01'}

If that works, you can resync your optimized InvoiceLine table by running:-

sp_optimizefullsync InvoiceLine

See also: How do I setup the QODBC Optimizer? Where are the Optimizer options?

That didn't seem to work.  For now, I'm just working with the sample.qbw file.

I'm trying to use Hibernate with the QODBC.  Hibernate needs a dialect which is usually set to the database (SQLServer, Oracle, etc.).  Do you know what I can set it for QODBC?