Knowledgebase: TroubleShooting
[QODBC-POS] QODBC POS could not access to QuickBooks POS Company File
Posted by Jack - QODBC Support on 02 March 2015 12:38 PM

QODBC POS could not access to QuickBooks POS Company File

Problem Description:

When set QODBC POS DSN to access the company file that is running in QuickBooks POS (Version 10), it will fail to connect to the company file. QuickBooks POS will search for the server with no response.

Solutions:

There is limitation QuickBooks POS SDK 10 that it will not able to get current open company file name & thus QODBC POS is not able to connect currently open company file.

QuickBooks POS SDK Test Plus tool also required connection string It will not connect QuickBooks POS without connection string.

For Example:

Connection String = " ComputerName=WIN-O8RQBVCMJFC;CompanyName=SampleCompany;Version=10 "

As a workaround of this issue, you need to provide the connection string to connect company file. Please follow below steps:

1) Please change QuickBooks POS to run in multi-user mode. Click "Switch Company File to Multi User Mode" option in File Menu. 

 

http://support.flexquarters.com/esupport/newimages/QODBCPOS/step1.png

 

2) Build Connection String:

Click "..." button at QODBC POS Setup Screen->General Window to enter company file selection window: 

http://support.flexquarters.com/esupport/newimages/QODBCPOS/step2.png

 

3) In company file selection window, QODBC POS will give you a list of all available company file (may take a few seconds) :

 

http://support.flexquarters.com/esupport/newimages/QODBCPOS/step3.png

4) 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:  

 

http://support.flexquarters.com/esupport/newimages/QODBCPOS/step4.png

 

5) 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:

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

 

http://support.flexquarters.com/esupport/newimages/QODBCPOS/step5.png

 

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

 

http://support.flexquarters.com/esupport/newimages/QODBCPOS/step6.png

(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).