We currently are experiencing some difficulties with using QODBC to connect CR2008 and QB8. All tables besides the Invoice and Invoiceline tables work perfectly. One of the reports created accesses all invoices not paid, QOBDC only returns one entry from 2006.
I moved the QB file on my personal computer (at first attributed the issue to insufficent resources on the server) and received the same results. I ran the verify and rebuild utility using my computer (Windows XP) and was able to run the report perfectly once complete.
After moving the company file back to the server, the next morning the issue reoccured. At this point I am not sure what is causing this issue. Any help with this matter would be greatly appreciated. Thanks!