Knowledgebase
[QODBC-POS] Connecting to QuickBooks POS failed because of a Windows security issue, Test Connection Not Working
Posted by Jack - QODBC Support on 25 November 2016 11:00 AM

Connecting to QuickBooks POS failed because of a Windows security issue. Test Connection was Not Working

Problem Description:

The QODBC Driver for QuickBooks POS runs differently under Microsoft Vista/W7 than other versions of Windows because of its new strict security settings.

If the Test connection is unsuccessful and shows Connecting to QuickBooks POS failed because of a Windows security issue, you have forced Administrator rights. The setup must be run without "Run As Administrator," and UAC must be turned on to Test the connection.

Solutions:

When you run the QODBC POS Setup screen from ODBC Manager, the Setup Screen runs as "elevated permissions," and QODBC POS runs as "elevated permissions."
QBPOSSDK & QuickBooks POS are running as "NON-elevated permissions" Thus, both cannot talk, and you will face this error.

Follow the below steps to resolve the issue:

Close QODBC POS Setup Screen, Close Data Source Administrator ( if Open).
Click Start -> All Programs -> QODBC Driver for use with QuickBooks POS -> QODBC POS Setup Screen.

Perform Test Connection
 

Data Source Administrator ( which by default runs as "Run as Administrator" ) If the above does not resolve the "Test Connection" Security issue, please follow the below steps.

Alternative

Use QODBC POS Test Tool or any other application like MS Access, Excel, or your custom application and connect to the DSN; it should get connected ( Even though  "Test Connection to QuickBooks" is not enabled or is having a Windows security issue. )

Refer: How to Install QODBC POS and Connect to QuickBooks POS

If QODBC POS Test Tool can connect, you should be able to use QODBC with your application(s).
You can find QODBC POS Test Tool at Windows Start->All Programs->QODBC Driver for use with QuickBooks POS>>QODBC POS Test Tool

If QODBC POS Test Tool can connect, you should be able to use QODBC with your application(s). There is no need to test the connection via QODBC POS Setup Screen once it has passed connect via QODBC POS Test Tool. You may ignore the Test Connection windows security message as Test Connection may fail if executed in a different context than a regular user.

 

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