| Windows Scheduler URGENT Help Needed |
| Author |
Message |
|
|
| Posted : 2010-01-15 14:37:19 |
Hi Everyone,
We're have this weird situation here. We've developed a windows console application using VB.net, which is installed on the same server as QuickBooks installed. This problem will Sync some information between the QuickBooks database and a remote MS SQL database. The application also create log records in the SQL server to tell me it that Sync process went successfully. It's kind of a small application (.exe file), if I login to the server through Remote Desktop, find the .exe file, and double click on it, this application works perfectly. Then I tried to schedule this .exe using windows scheduler and make it run every night. It never works, and from the log records, the errors are all the same, which is "QODBC ERROR: [QODBC] QB Open Connection Failed. Create DCOM Instance Error = 80070005, Unknown error.. Created qbXMLRP2 OK.".
I did some research on the forum, and I've done everything that I could try, but nothing works. I just don't understand why that an application can be run manually, but won't work with windows scheduler? Has anyone got any suggestions? or had the same issues with windows scheduler? By the way, with Remote Desktop, I logged in as "administrator", and the windows scheduler uses the same role to run the application.
Thanks for any advises. Regards Harry |
|
|
|
|
|
| Posted : 2010-01-16 00:16:46 |
|
|
|
|
|
| Posted : 2010-01-16 08:48:37 |
| Hi Tom,
Thanks for the reply, but I did try the procedures in the thread you provided before I posted my issue here.
That didn't solve the problems.
Regards
Harry |
|
|
|
|
|
| Posted : 2010-01-16 13:27:04 |
|
|
|
|
|
| Posted : 2010-01-16 22:50:20 |
| Hi Tom,
We've tried everything we can as suggested, but still have the same problem.
I'm sure the DCOM has been set up as the threads you provided.
There's one big improvement so far. I changed the permission on folder "C:\Users\Administrator\Program Files\QODBC Driver for QuickBooks\" (I don't know why it's not C:\Program Files\QODBC Driver for QuickBooks\, and looks like is the only folder that I have in "C:\Users\Administrator\Program Files\") for Interactive User, I can now run the script successfully in Schedule Task (run task now). Before, that didn't even work. But it's only working when I still logged in as "administrator", once I logged out, and let the schedule to run automatically, it failed again.
Any more thought about the solutions? Looks like it's definitely some permission errors, and we getting very close.
Thanks
Harry |
|
|
|
|
|
| Posted : 2010-01-18 13:04:07 |
| QuickBooks is not a Windows Service, it needs to run as a local console application, so you must be logged on as the "Administrator" on the server so QuickBooks can run when called by your script (via QODBC). |
|
|
|
|
|
| Posted : 2010-01-18 13:45:29 |
| Hi Tom,
Thanks, so is there any ways that I can schedule the script to run as the way I want?
Anything settings in the windows scheduler would help this?
Thanks
Harry
|
|
|
|
|
|
| Posted : 2010-01-18 16:34:32 |
|
|
|
