[QODBC-Desktop] Connecting to QuickBooks failed because of a Windows security issue, Test Connection Not Working
Posted by Rajendra Dewani (QODBC Support) on 16 July 2013 07:12 AM
Connecting to QuickBooks failed because of a Windows security issue. The Test Connection was Not Working.
The QODBC Driver for QuickBooks 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 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.
When you run the QODBC Setup screen from ODBC Manager, the Setup Screen runs as "elevated permissions," and QODBC runs as "elevated permissions."
Follow the below steps to resolve the issue:
Close QODBC Setup Screen, Close Data Source Administrator ( if Open).
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.
Use QODBC Support Wizard, 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 a Windows security issue. )
For troubleshooting connection issues, refer: To how to use QODBC Support Wizard.
If QODBC Support Wizard or 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, but if you cannot find it, please refer to the below article:
If you are not familiar with VB Demo, please refer below article first:
If QODBC Support Wizard or 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 than a normal user, and there is no need to test the connection via QODBC Setup Screen once it has passed connect via QODBC Support Wizard or VB Demo.
I just upgraded to version 15
Please keep QuickBooks running, logged in as Admin to your company file, Switch to single-user mode and try to connect using your application.
Please refer to the below-mentioned article for Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video):
Keywords: UAC login