[QODBC-Desktop] How to connect to multiple company files at the same time/simultaneously
Posted by Jack - QODBC Support on 30 October 2015 09:22 AM
How to connect to multiple company files at the same time/simultaneously
There are multiple company files in QuickBooks. At a time, I can access only one company file. Is QODBC allow me to access multiple company files same time?
To access multiple company files, a user can create multiple DSNs; each DSN is set up to auto-login to one company file.
Please refer How to setup QODBC for auto-login into QuickBooks.
If you want to access a different company file, just change the DSN name to the one point to that company file.
Please make sure QODBC has got permission from all company files.
A user needs to start QuickBooks, log in to company file as Admin, Single user mode, and connect to that company file using QODBC Test Tool/User Applications, It should popup a certificate, and the user needs to accept the certificate so that QODBC can access company file data.
This activity should be done only a single time for each company file. After accepting certificates from all company files using MS Excel and dump the data into spreadsheets for each company in sequence and then merge the sheets.
Please Note: QuickBooks SDK can access only one company file at a time.
It means you cannot access multiple company files at the same time.
You need to close the 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.)
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 machine having QuickBooks and QODBC installed. Each machine will have a different QuickBooks company file opened in the QuickBooks application. Application machine uses QRemote Client (different DSNs) to connect to those machines and access QuickBooks company file data simultaneously.
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.
Keywords: QB win log with multiple companies, log in with multiple companies