Knowledgebase
[QODBC-Desktop] How to Setup QODBC to Access QuickBooks when there is no-one logged in
Posted by Rajendra Dewani (QODBC Support) on 17 April 2014 11:20 AM

How do Setup QODBC to Access QuickBooks when there is no one logged in

Instruction:

QuickBooks is not a windows service, so it cannot run when no one is logging into the system. This limit brings problems when the user tries to set up QODBC to access QuickBooks via Task Scheduler or other similar services. To use QODBC to access QuickBooks, a QB instance must be running at the front or background for accessing. When no one is logged in, QODBC fails to call QB SDK to launch a QuickBooks instance. This is an expected behavior, and QuickBooks UI, QuickBooks SDK, and QODBC/QRemoteServer are not designed to run when no one is logged in to a windows desktop. Or it cannot be run as Service.

Well, for a few OS like Windows 7, you may try using DCOM (as a workaround) to allow QODBC to connect to QuickBooks without logging into Computer.

This article will show you how to set up an ap DCOM server for QODBC to access QuickBooks when no one is logging in.

Note: Below steps may or may not work for ALL Operating Systems and have a few limitations. QuickBooks may throw the error "Could Not start QuickBooks," Or QBW32.exe may not close properly. Please note QuickBooks UI, QuickBooks SDK, and QODBC are designed to run on an Active windows desktop session. Running it on DCom/Service may cause an unstable connection/disconnect to QuickBooks.  We do not support running QODBC/QRemoteServer as a service or running it when no one is logged in.  

Run DCOMCNFG.EXE

Please enable the "DCOM Server" option in QODBC Setup Screen to work with DCOM Server.

Go to Windows Start. In the command line, input "DCOMCNFG.EXE."

In the "Component Service" window, go to Console Root -> Computers -> My Computer -> DCOM Config:

Right-click entity "qbXMLRP2eQODBCInteractive" and select the "Properties" option to open the "Properties" window:

Setup Security Properties:

Go to the "Security" tab, and select the "Customize" option at "Launch and Activation Permissions" and "Access Permissions":

Click the first "Edit" button to edit "Launch and Activation Permissions." In the Edit window, click the "Add" button to add "everyone" to the user group.

And then give local and remote permissions to account for "everyone."

Click the second "Edit" button to edit "Access Permissions." In the Edit window, add "everyone" into the user group as you did when editing "Launch and Activation Permissions."

And then give local and remote permissions to account for "everyone," too.

Select Identity Method:

After adding "everyone" to the user group, please turn back to the Properties window and go to the "Identity" window.

Different applications and systems may require other Identity Methods to make the DCOM Server work. Please test each method to determine which can work in your environment.

If the above does not work, change the option, restart your machine and try again.

If the above does not work, change the option, restart your machine and try again.

You can refer to This Article for more information about DCOM Server configuration.

After the DCOM Server configuration is completed, please restart your Computer. Then you can set up QODBC to access QuickBooks when no one logs into the system.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).