I used QuickBooks 2004 and QODBC 7 to import data from QB into SQL Server 2000.

Later I upgraded both QB to QB 2007 and QODBC to v8.

If I open Bill table in SQL Server I see a lot of records there. If I run "Select * from Bill" in VBDemo I get no records at all. I get no records from BillItemLine, BillExpenseLine.

I get a very small number of records from BillToPay table, but they have blank fields PayeeEntityRefListID and PayeeEntityRefFullName.

Where all the Bill info has gone? I see all bills via QB interface. No info via VBDemo or via my VB 6 application.

Thank you

Vlad

I do not use now SQL Server. I'm trying to run queries from VBDemo and from my VB6 application.

Queries from the link you provided give me 'QODBC: Unexpected extra token: (' error

One more question: Is there any topic giving VB6 syntax for  inserts and updates? Regular SQL server syntax doesn't work. As I see from some posts there are some extra double quotes, 2 double quotes.

For instance in SQL Server I never surround the column name with double quotes. With QODBC it's different.

Thank you

Ok, I can't tell which way you're using SQL Server. See: Can I get some examples of how to use QODBC via Visual Basic? for VB examples and reset your optimizer tables as per: How do I switch OFF or RESET the QODBC optimizer?