Troubleshooting: First Time Optimizer Runs "Waiting on QuickBooks" for a long time

Problem Description

     I am using QODBC with the RDS server. I have one workstation that runs the optimizer and queries just fine. I installed QODBC on a second with the same settings. I pressed the Load Updated Data button after installation to run the optimizer. It gets the transaction table, and I get the message "Waiting on QuickBooks." I have had the message for hours. I installed QODBC on a 3rd workstation with the exact settings, and this time I ran the QODBCFUL program. It runs for a while, and I get the Waiting on QuickBooks message again. I go back to the first computer and run QODBCUPD, and optimizing is no problem.

     And I also ran the "select * from transaction VERIFY" query from the QODBC Support Wizard to rebuild the corrupted optimized Transaction table. It optimizes the transaction table with the status window saying transaction optimizing table. It ran for about 20 minutes; a 2nd status box showed up. It says transaction waiting on QuickBooks. That has been up for over 10 minutes now.

Solutions

     This can take hours on a huge company file. The Waiting on QuickBooks is how long it takes QuickBooks to create the record set (Not even sending QODBC data yet).
The other pauses are QuickBooks converting 500 records into XML at a time.
     One other option to get similar data is sp_report CustomTxnDetail report output.

     See also: How to setup QODBC Optimizer and where are the Optimizer options

           How to switch OFF or RESET the QODBC Optimizer