[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 Not Working
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 Test connection is not successful and shows Connecting to QuickBooks POS 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.
When you run QODBC POS Setup screen from ODBC Manager, the Setup Screen runs as "elevated permissions", QODBC POS running as "elevated permissions"
Follow below steps to resolve the issue:
Close QODBC POS Setup Screen, Close Data Source Administrator ( if Open).
Perform Test Connection
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.
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. )
If VB Demo can connect, you should be able to use QODBC with your application(s).
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 POS Setup Screen once it has passed connect via VB Demo.