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

Connecting to QuickBooks Online failed because of a Windows security issue, Test Connection Not Working

Problem Description:

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

If Test connection is not successful and shows Connecting to QuickBooks Online failed because of a Windows security issue, it means that 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 QODBC Online Setup screen from ODBC Manager, the Setup Screen runs as "elevated permissions", QODBC Online running as "elevated permissions"

Follow below steps to resolve the issue:

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

Perform Test Connection using "Connect to QuickBooks" button from QODBC Online Setup Screen

Refer: How to use QODBC Online with QuickBooks Online Edition

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

Alternative

Use VB Demo 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 Windows security issue. )

Refer: Connecting QODBC Online Driver to QuickBooks Online for the First Time (Video)

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

If VB Demo can connect, you should be able to use QODBC 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 Online Setup Screen once it has passed connect via VB Demo.

 

Even though
(0 vote(s))
Helpful
Not helpful

Comments (1)
Bryan Bostrom
19 April 2018 10:19 PM
If you use 64-bit Access and thus must use QRemote, then your problem may be that the IP Address in your 64-bit connection does not match the IP Address QRemote is looking for. To fix this,

1. Start QRemote
2. In Windows System Tray, click the green qRemote icon & right click on it. Choose "Show QRemote Server
3. Take note of the IP Address listed
4. Open your 64-bit QODBC DSN & Configure it with the IP address QRemote shows

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