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.

1 Answer 1

Flexquarters states that the user must be logged into QuickBooks or the QODBC process will not run successfully. They told me that this was due to the QuickBooks SDK requirements and there was nothing Flexquarters could do about it.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.