[QODBC-Desktop] How to run QODBC applications on a repeating/nightly basis
Posted by Jack - QODBC Support on 19 October 2015 12:35 PM
How to use QODBC with Windows scheduler / How to use Z-Cron with QODBC / How to run QODBC applications on a repeating/nightly basis
Problem Description 1:
My application needs to read data from QuickBooks and update data in the SQL server. Up to this, I can handle everything. But I need a solution for the task scheduler. My need is my application needs to run every hour through the task scheduler. I'm trying this, but it is giving the error message:
"Could not start QuickBooks."
Problem Description 2:
I have a batch file that runs a query using the QODBC driver. It ran perfectly when I logged in, but when I ran it as the scheduled task, I got this error:
Unable to connect to QuickBooks Connection String: DSN=BPCQB_PROD_batch; DFQ=; OpenMode=F; SERVER=QODBC, OLE Automation Error. The source is Microsoft OLE DB Provider for ODBC Drivers." [QODBC] Server Edition of QODBC is required to use the DCOM Servers."
Windows Scheduler has changed from Desktop base to Service based from Vista or Win7 onwards, and the new OS has the Scheduler as Service based.
QuickBooks and QODBC are desktop-based applications/drivers.
Even if you have specified the username/password and have a user logged into the machine, you may notice the same error. This is because the task executed from Task Scheduler runs as a different user / new session.
How to use Z-Cron with QODBC
You can download Z-Cron from below mentioned link:
After downloading Z-Cron, please install it on your machine.
After Installation, please start Z-Cron and add a task by Clicking the "Task" button.
Enter Task Title in the Label box & enable the "Activate Task" option to activate the scheduled task and choose Program by clicking the ".." button.
Select the file which you want to schedule & click "OPEN." In this example, I am selecting the VBS script.
Now navigate to the "Scheduler" tab to schedule export. In this example, I am scheduling export to every day two times (i.e., 8:00 AM & 5:00 PM).
Click on the "Every day" button to select all weekdays & click on "Scheduler" to configure schedule timing.
Select a time & click on "Save."
Now save the scheduled job by clicking the "Save" button
The scheduled appointment is saved.
The scheduled task is ready for execution. It will be run on schedule time.