Knowledgebase
[QODBC-POS] How to Install QODBC POS and Connect to QuickBooks POS on Windows XP
Posted by Rajendra Dewani (QODBC Support) on 16 October 2012 11:04 AM

How to Install QODBC POS and Connect to QuickBooks POS on Window XP

Please refer How to Install QODBC POS and Connect to QuickBooks POS on Windows 10 for using QODBC POS on Windows 10 or other latest OS.

Install QODBC POS

Please download QODBC Installer from this site:

http://www.qodbc.com/posDownload.htm

Right Click on the Installer and select, "Run As Administrator"

Please remember to uncheck the "Protect My Computer and Data From Unauthorized Program Activity"

Follow the Installation steps from the Installer,  On the CDKEY Step:

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 time.

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 via Windows Start-> All Programs->QODBC Driver For Use with QuickBooks Pos->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:

Note: If you are getting UAC error on Test Connection, Please try to connect using VB Demo or Excel. If VB Demo or Excel can connect, you should be able to use QODBC POS with your application(s). You may ignore the Test Connection windows security message as Test Connection may fail if it is executed in a different user context then normal user and there is no need to test connection via QODBC Setup Screen once it has passed connect via VB Demo or Excel.

In this "Enter Company Name" window, please provide your QuickBooks POS company file name and your work station name (Machine Name). In case it does not connect and report this error:

Please try again by clicking "Cancel" button in "Enter Company Name" window. And if you still facing the same error, please change QuickBooks POS to run in multi-user mode. Click "Switch Company File to Multi User Mode" option in File Menu.

Build Connection String

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:

Click "Yes Always" button. If QODBC POS tells you the connection is successful, then you can use our test tools VB Demo to view QuickBooks POS records via QODBC POS. Please select VB Demo via Windows Start->All Programs-> QODBC Driver for use of QuickBooks POS->VB Demo or you can directly go to C:\Program Files\QODBC Driver for QuickBooks\VBDEMO32.EXE to find it.

In VB Demo, click "Connection"->"Add New Connection", then VB Demo will ask you to select a QODBC POS DSN to access QuickBooks POS:

Select DSN "QuickBooks POS Data" and click OK, now you can use SQL statement to access QuickBooks POS:

And in QuickBooks POS references, you can see that QODBC POS has been included in the list of allowed applications:

 

Keywords: Qbpos tables

(0 vote(s))
Helpful
Not helpful

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