Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a batch file (.BAT) set up on a Windows 7 PC running QB Premier 2012 that uses a SQL client to connect to a Quickbooks company file through QODBC (latest version) that works fine when run ad hoc by the user (i.e., connection works, QODBC panels show and I get good output in the extracts).

However, when trying to schedule the batch file in Task Scheduler it appears to run but I get empty output files. I have been through all the possibilities of TS configuration on this (local security policy settings for logon as batch, configuring the batch file to run as administrator, ad nauseum...) without success. Also tried the AT command but was also not successful.

I believe the issue is that TS does not run the process in interactive mode and since the TS EXE is initiating the connection as the parent calling image QB probably wants to authorize the connection again, but since we don't get any UI when run from TS it's tough luck.

Any insights much appreciated as this has been a time thief like you would not believe.

share|improve this question

migrated from serverfault.com Dec 19 '11 at 1:39

This question came from our site for professional system and network administrators.

add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.