Troubleshooting - Scheduled Task Job not working after upgrading QODBC
We use software called RemiCrystal to generate reports for emailing. The reports have always worked fine using QB 2013 Pro and QODBC v14 (I think v14). Then we upgraded to QuickBooks 2014 R7P and the QODBC to 15.00.00.305 and since then the automated running of the RemiCrystal tasks has failed on a QODBC request. If I run the job manually, the reports are generated correctly and emailed out with no issues, however, the scheduled run of the job is not gathering data from QuickBooks so the report times out after 15 minutes and exits.
I have generated the ODBC Trace Logs and I can see in the log that when the job runs manually, QODBC is triggered and starts to connect to the QuickBooks data file, then does not process any requests in the format of the data. Can you give me an idea of what to look for?
I think you are using DCOM Server to run scheduled task job.
As an alternative to DCOM server, Please use QRemote, please refer below articles for more information: How to create Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC/QRemote
The DCOM is an obsolete project and development/bug fixes are no more possible. While QRemote is current project development/bug fixes are possible.
DCOM configuration is tricky & hard, while QRemote configuration is easy.
DCOM is work with 32-bit application only, It will not work with the 64-bit application. While QRemote will work with both 32-bit & 64-bit applications.
If you are still want to use DCOM, then I would like to inform you that you need to setup DCOM server manually again. Please refer below mentioned articles for configuring DCOM Server. Please refer manual configuration steps & try again:
How to setup QODBC DCOM Server
DCOM Option / Server Edition Tab missing in QODBC Setup Tab