ODBC Driver for QuickBooks POS

Build 22.0.8462

Connecting to a Local Company File

Follow the steps below to authorize with QuickBooks POS and connect to a company file when both QuickBooks POS and the driver are running on your local machine.

  1. Open QuickBooks POS as an administrator and open the company file you want to connect to.
  2. Connect to QuickBooks POS. A dialog will appear in QuickBooks POS prompting you to authorize the driver. After granting access to the driver, you can now execute commands to QuickBooks POS.
  3. If you want to connect to the company file when QuickBooks POS is closed, set the CompanyFile connection option when you execute commands. QuickBooks POS will open automatically in the background with the file specified.

    Note that if QuickBooks POS is open through the application UI, only that CompanyFile can be used.

Connection Troubleshooting

If you receive a connection error (such as "Internal error 160002") you may need to switch QuickBooks POS to multiuser mode. This is done by selecting the "Switch Company File to Multi User Mode" option in the File Menu. You should then be able to connect to the company file.

If a CompanyFile is not specified in the connection string, QuickBooks POS may present an "Enter Company Name" window the first time you connect. In this window, you must specify the company file and the computer name where the company file is located.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462