I am able to connect using VB Demo, but cannot connect using 64-bit Excel.
(Video)Īccessing QuickBooks data with QODBC Driver using MS Excel 2010 & MS Access 2010 (Video)
How to setup QODBC Driver to auto-connect to QuickBooks. Test Connection Button On QODBC Setup Is Grayed/Disabled If you are able to connect through QODBC Support Wizard or VB Demo, then please try to test again through your application. (Video):Īccessing QuickBooks Data Remotely using QODBC & QRemote Please refer below mentioned article for Accessing QuickBooks Data Remotely using QODBC & QRemote.
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 Setup Screen once it has passed connect via QODBC Support Wizard or VB Demo.Ĭonnecting QODBC Driver to QuickBooks for the First Time (Video) If QODBC Support Wizard or VB Demo can connect, you should be able to use QODBC with your application(s). Please try to test the connection using QODBC Support Wizard or VB Demo application. Your QuickBooks file should be accessible and should not be in the restricted folder. Please keep QuickBooks running, logged in as Admin to your company file, Switch to single user mode and try to connect using your application. When I go to QODBC setup screen and click test connection to QuickBooks I getĬonnecting to QuickBooks failed because of a window security issue Solution:
I have the server version (CD key code ) installed on the IIS machine I have an IIS machine and a QuickBooks Machine 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 Setup Screen once it has passed connect via QODBC Support Wizard or VB Demo. If QODBC Support Wizard or VB Demo can connect, you should be able to use QODBC with your application(s). If you are not familiar with VB Demo, please refer below article first: You can find VB Demo at Windows Start->All Programs->QODBC Driver for use with QuickBooks, but if you could not find it, please refer below article:
)įor troubleshooting connection issue refer: How to use QODBC Support WizardĪlso, Refer: Connecting QODBC Driver to QuickBooks for the First Time (Video)
Use QODBC Support Wizard or 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. QBSDK & QuickBooks running as "NON-elevated permissions" Thus both cannot talk and you will face this error.Ĭlose QODBC Setup Screen, Close Data Source Administrator ( if Open).Ĭlick Start -> All Programs -> QODBC Driver for use with QuickBooks -> QODBC Setup Screenĭata Source Administrator ( which by default runs as "Run as Administrator" ) If above does not resolve the "Test Connection" Security issue, Please follow below steps. When you run QODBC Setup screen from ODBC Manager, the Setup Screen runs as "elevated permissions", QODBC running as "elevated permissions" The setup must be run without "Run As Administrator" and UAC must be turned on to Test the connection. If Test connection is not successful and shows Connecting to QuickBooks failed because of a Windows security issue, it means that you have forced Administrator rights. The QODBC Driver for QuickBooks runs differently under Microsoft Vista/W7 than other versions of Windows because of its new strict security settings.
Posted by Rajendra Dewani (QODBC Support) on 16 July 2013 07:12 AMĬonnecting to QuickBooks failed because of a Windows security issue, Test Connection Not Working