How to connect to multiple company files at the same time/simultaneously

Problem:

There are multiple company files in QuickBooks. At a time, I can access only one company file. Does QODBC allow me to access multiple company files at the same time?

Solution:

To access data from multiple QuickBooks company files, you must configure a dedicated Data Source Name (DSN) for each individual file. Each DSN should be configured to handle auto-login for its respective company file. For detailed setup steps, please refer to the guide: How to set up QODBC for auto-login into QuickBooks.

To switch between different company files, simply update your application's connection string to point to the specific DSN associated with that company file.

Please refer to How to set up QODBC for auto-login into QuickBooks.

Step 1: Granting QODBC Access Permissions

Before attempting automated data extraction, QODBC must be granted permission by each QuickBooks company file. This configuration is a one-time requirement per company file.

Follow these steps for each file:

1. Open QuickBooks and log into the target company file as a QuickBooks user Admin in Single-User Mode.

2. Connect to the company file using the QODBC Test Tool or your integrated user application.

3. A QuickBooks integrated application certificate prompt will appear.

4. Accept the certificate and grant the necessary permissions to allow QODBC to access the data.

Step 2: Extracting and Consolidating Data

Once all certificates are accepted, you can proceed with data extraction:

1. Use an application such as Microsoft Excel Or Access Or your custom application to connect to each DSN sequentially.

2. Export/dump the required data for the company.

3. Close the connection, and wait for 15 seconds before connecting to the next company file.

Important Technical Limitations

⚠️ QuickBooks SDK Connection Constraint The QuickBooks SDK can only connect to one company file at a time. It does not support concurrent connections to multiple company files.

Because simultaneous access is not supported, your data extraction workflow must strictly follow a sequential connection process. You must completely close the connection to the active company file before opening a connection to the next one.

• Required Delay: To ensure QuickBooks completely releases the previous session, implement a 15 to 30-second delay (gap) between closing Connection A and opening Connection B.

Potential Error Messages

If an application attempts to access multiple company files concurrently, or if a new connection is initiated too quickly without the required delay, the system will return the following error:

If the user tries to access multiple company files at the same time, then you will receive the error:

As a workaround, you can use multiple machines, each with QuickBooks and QODBC installed. Each machine will have a different QuickBooks company file opened in the QuickBooks application. The application machine uses QRemote Client (different DSNs) to connect to those machines and access the QuickBooks company file data simultaneously. 

For Example:
On Application Machine.
QRemote Client DSN A --> Points to IP Address of Machine A --> Machine A will have QuickBooks company file A opened.

QRemote Client DSN B --> Points to IP Address of Machine B --> Machine B will have QuickBooks company file B opened.

QRemote Client DSN C --> Points to IP Address of Machine C --> Machine C will have QuickBooks company file C opened.

Also, Refer:
How to create or configure a QRemote DSN

 Keywords: QB win log with multiple companies, log in with various companies