[QODBC-POS] How to Install QODBC POS and Connect to QuickBooks POS on Windows Vista / Windows 7 Operating System
Posted by Rajendra Dewani (QODBC Support) on 25 September 2012 09:54 AM
How to Install QODBC POS and Connect to QuickBooks POS on Windows Vista/ Windows 7 Operating System
Install QODBC POS
Please download QODBC Installer from this site:
Then run it as administrator: (Right-click on the Installer and select "Run As Administrator")
If you have purchased a license key, you can directly input your key to get QODBC POS full functional, but if this is the first time you install QODBC POS, you can leave this option blank to get a 30 days evaluation.
You can setup QODBC POS default DSN via Windows Start->All Programs->QODBC Driver for use with QuickBooks POS->QODBC POS Setup Screen. And if you found
And if you find "Evaluation Expired", "Unable to open license" or "Open license failed" description in About Window of QODBC POS Setup Screen:
Please run QODBC POS Setup Screen as administrator: ( Required Only Once )
If this is the first time you run QODBC POS and you have to skip CDKEY step in installing, the About Window should be like this:
Connect to QuickBooks POS via QODBC POS
First, please open QuickBooks POS:
Please make sure you are in a single user mode, in the File menu, there is an option "Switch Company File to Multi-User Mode" which shows that you are in single mode:
And then open QODBC POS Setup Screen. Please leave "Current Company Setting" option blank so that QODBC POS could directly access the company file that is running in QuickBooks POS. And then click "Test Connection" button:
Then QuickBooks POS will ask you to grant permissions for QODBC POS:
Click "Yes Always" to continue, and QODBC POS will report connection successful if everything is ok:
And you can also use QODBC POS Test Tool to test the connection. You can simply find our test tools QODBC POS Test Tool via Windows Start->All Programs->QODBC Driver for use with QuickBooks POS->QODBC POS Test Tool:
To establish a connection in the QODBC POS Test Tool window, select the "QuickBooks POS Data" DSN from the dropdown list and click on "Connect".
Now you can access the QuickBooks POS company file via QODBC POS Test Tool:
Note: QODBC Support Wizard is used to test QODBC SQL queries only and is not a development tool.
Run QODBC POS with QuickBooks POS under Multi-User Mode
Run QODBC POS with QuickBooks POS under multi-user mode allows you to access and modify QuickBooks company file when other users logs in. And you can also build a connection string to assign a company file to the DSN so that you don't need to open QuickBooks POS when you use the DSN.
First, please switch QuickBooks POS to multi-user mode, click "Switch Company File to Multi User Mode" option to turn QuickBooks POS to multi-user mode:
Then open QODBC POS Setup Screen, Click "..." button at QODBC POS Setup Screen->General Window to enter company file selection window:
In company file selection window, QODBC POS will give you a list of all available company file (may take a few seconds) :
Select the company file you want to access, and then click ok. then you will see the connection string has been built in "Current Company Setting" option. And then please click "Test Connection" Button:
QuickBooks POS will ask you to grant permission to QODBC POS again, click "Yes Always" button. If QODBC POS tells you the connection is successful, then you can use our QODBC POS Test Tool to view QuickBooks POS records just the same as what you did in single user mode.