[QODBC-Desktop] Troubleshooting - Getting Error This file is in use
Posted by Jack - QODBC Support on 17 November 2016 11:37 AM

Troubleshooting - Getting Error This file is in use

Problem Description:

We are trying to use your drivers to connect to 3 different QuickBooks files. But when I browse to the first file to setup the ODBC data source I get this message:


We are dead in the water right now... I was hoping it was as easy as setting up 3 ODBC DSN's and then my other apps could connect.

Can you help us with how to get this setup without needing to have the company file manually opened by someone? We want this to work automatically in the back end and have to switch between the 3 company files on the fly so it's not practical to have a user open the company file manually.

Solution 1:

You can copy QuickBooks company file path from QuickBooks UI & paste it to QODBC Setup Screen company file path configuration.



Solution 2:

You will get this error when the company file is open in QuickBooks. So you need to close company file from QuickBooks & try again.

Please refer How to create or configure a QODBC DSN for setting up 3 ODBC DSN's.

Please refer Connecting multiple QuickBooks companies via QODBC

There is a limitation with the QuickBooks SDK that it can connect only 1 company file at a time a user session.

It means you cannot access multiple company files at the same time.

You need to close connection with one company file and switch to another company file. ( i.e. connection close for company A and Connection open for company b, should have a gap of 15-30 seconds for switching operation.)


(1 vote(s))
Not helpful

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