Troubleshooting - Scheduled Task Job not working after upgrading QODBC
We use software called RemiCrystal to generate reports for emailing. The words 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 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 jobs.
As an alternative to the DCOM server, Please use QRemote. Please refer to the below articles for more information: How to create a 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 works with 32-bit applications only. It will not work with the 64-bit application. While QRemote will work with both 32-bit & 64-bit applications.
If you still want to use DCOM, I would like to inform you that you need to set up the DCOM server manually again. Please refer to the articles mentioned 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