[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 the Test connection is unsuccessful and shows Connecting to QuickBooks Online 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 Online Setup screen from ODBC Manager, the Setup Screen runs as "elevated permissions," and QODBC Online runs as "elevated permissions." Follow the below steps to resolve the issue: Close QODBC Online Setup Screen, Close Data Source Administrator ( if Open). Perform Test Connection using the "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 the above does not resolve the "Test Connection" Security issue, please follow the below steps. Alternative Use QODBC Online 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: Connecting QODBC Online Driver to QuickBooks Online for the First Time (Video) If QODBC Online Test Tool can connect, you should be able to use QODBC with your application(s). If QODBC Online 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 Online Setup Screen once it has passed connect via QODBC Online Test Tool. There is no need to test the connection via QODBC Online Setup Screen once it has been connected via QODBC Online Test Tool. You may ignore the Test Connection windows security message as Test Connection may fail if executed in a different context than a normal user. Tags: QuickBooks Online, QBO, QODBC Online, Windows Vista, 7, QODBC Online Test Tool
Even though
| |
|
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.