Knowledgebase
[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.

Solutions:

When you run the QODBC Setup screen from ODBC Manager, the Setup Screen runs as "elevated permissions," and QODBC runs as "elevated permissions."
QBSDK & QuickBooks are running as "NON-elevated permissions" Thus, both cannot talk, and you will face this error.

Follow the below steps to resolve the issue:

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

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.

Alternative

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.

Also, Refer: Connecting 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).

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:
Troubleshooting: VB Demo is missing

If you are not familiar with VB Demo, please refer below article first:
How to use the VB Demo for testing

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.

Problem:

I just upgraded to version 15

I have installed the new versions.

I have an IIS machine and a QuickBooks Machine.

I can connect to the QuickBooks machine.

I have the server version (CD key code ) installed on the IIS machine
when I go to the QODBC setup screen and click test connection to QuickBooks I get
Connecting to QuickBooks failed because of a window security issue

Solution:

Please keep QuickBooks running, logged in as Admin to your company file, Switch to single-user mode and try to connect using your application.

Your QuickBooks file should be accessible and not in the restricted folder.

Please try to test the connection using QODBC Support Wizard or VB Demo application. 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.

Please refer:

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

Please refer to the below-mentioned article for Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video):

Accessing QuickBooks Data Remotely using QODBC & QRemote


If you can connect through QODBC Support Wizard or VB Demo, please try to test again through your application.

Also, Refer

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

Test Connection Button On QODBC Setup Is Grayed/Disabled

How to set up QODBC Driver to auto-connect to QuickBooks. (Video)

Accessing QuickBooks data with QODBC Driver using MS Excel 2010 & MS Access 2010 (Video)

 

Keywords: UAC login

Even though
(22 vote(s))
Helpful
Not helpful
Comments (22)
Jon Greising
10 December 2013 03:27 PM
trying to load for evaluation. I wish to purchase a single read-only license, but need to verify that the driver works first!
Frank Lowry
10 February 2014 02:02 PM
Just installed QODBC. I can not connect to Quickbooks. UAC is on and I am not running QODBC setup screen "as administrator". I am logged in as an administrator. I am trying to connect to Quickbooks from Crystal Reports. When I try to connect to my Quickbooks database using Database Expert, no Quickbooks database is shown.
Steve Woolsey
27 March 2014 03:44 AM
Installed trial version of QODBC. I am able to connect using VB Demo, but cannot connect using 64-bit Excel. I've followed setup instructions found here: http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2441/57/how-to-configure-qodbc-to-work-with-64-bit-ms-excel

One thing that is not clear to me from instructions is whether or not I've met this condition: " Before creating A DSN entry verify you have created a DSN entry for QODBC which can connect to QuickBooks. The ODBC Manager 32Bit can be found under Control Panel > ODBC ( 32 Bit )"

There is no such ODBC (32 Bit) icon in my Control Panel. How do I create a DSN entry for QODBC?

From "QODBC Setup Screen" the "Test Connection to QuickBooks" is successful.

From "Configure QODBC Data Source 64-bit" if I open normally or right click and run as administrator and click "Test Connection" on SystemDNS>QRemote>Configure I get the "QuickBooks failed because of a Windows security issue" error

From SystemDNS>QuickBooks Data 64-Bit QRemote>Configure>Test Connection I get the following error: [QODBC] QB Begin Session Failed. Error= 80040417, If the QuickBooks company data file is not open, a call to the "BeginSession" method must include the name of the data file" (even though company file is open, it tries to open a "secondary company file")

Any help is appreciated so I can evaluate the product.
Jack
07 July 2014 02:07 PM
Hi Steve,

I kindly request you to please refer below mentioned article for creating DSN:

http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/1929/48/how-to-create-or-configure-a-qodbc-dsn

Article contains information about 32 bit DSN, You can create 64 bit DSN same way from below mentioned location:
Start>> All Programs>> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source 64-Bit

I would like to inform you that:
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040417, If the QuickBooks company data file is not open, a call to the "BeginSession" method must include the name of the data file.

The above error is occurring when File path specified on QODBC Setup Screen is different from Company file opened in QuickBooks.

I kindly suggest you to verify the company file path on QODBC and QuickBooks, these two paths should be the same. You can find QODBC company file path via QODBC setup screen -> General tab. You could find the QuickBooks company file via QuickBooks UI, press F2 key you will see the file information.

If file path is same, then please restart machine & try again.

Please note, you can connect to only one company file at a time, if you want to connect to another company file you need to disconnect the connection from your application and connect to another company file.
If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Robert Weeks
14 April 2014 09:57 PM
can not connect to qb file
Running windows 7
QB file is on a file server
QB application installed locally
I had the QB file open in admin mode

Received the error Sybase obdc Driver sql anywhere unable to start database server
Jack
07 July 2014 01:57 PM
Hi Robert,

I would like to inform you that you’re using Sybase SQL Anywhere ODBC and Not QODBC. I kindly suggest you to refer below articles for how to use QODBC:

http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2511

Please note: you need select “QuickBooks Data” (if the applications is 32 bit) or “QuickBooks Data-64bit QRemote” (if the applications is 64 bit) when you choose data source instead of select other data source.
Edward JD
17 June 2014 11:47 PM
For evaluation, I just downloaded the trial of QODBC today to connect Ms Access 2007 to my company's old QuickBooks (version 2.0). It works pretty well with Windows XP at first time. However it's really pain to make it work in Windows 7. I did follow exactly instructions with QODBC Setup Screen & VB Demo for my workstation using windows 7 & after 3 days I could make it work. It worked, but not really well. Even in VB Demo, sometime it shows data, sometime not (???). For example, my company Estimates module has more than 10,000 records (in both Estimates header & Estimates Details), but most of the time, it shows 0 records in VB Demo. When I linked these tables in Ms Access 2007, it shows 0 records too. Now, the VB Demo can show all records in the tables above. It shows in Ms Excel too or Ms Query.
Jack
07 July 2014 12:22 PM
Hi Edward,

I kindly request you to please refer below mentioned article for missing data/records:

http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2453/0/getting-limited-number-of-records-or-few-of-the-records-is-missing-in-qodbc-table-result

If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

I kindly request you to share more information about the issue you’re facing, so that we can locate the problem quickly.

We may need following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About (Start>>All Programs>> QODBC Driver for use with QuickBooks>> QODBC Setup Screen >> About Tab )
2) Screenshot of the issue you’re facing.
3) Share the SQL statement you’re using.
Share Entire Log Files as an attachment in text format from
4) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
5) QODBC Setup Screen -- > Messages -- > Review SDK Messages
A Mehta
27 June 2014 03:29 PM
I am having a similar issue as Frank Lowry. What some possible solution.
Jack
07 July 2014 01:58 PM
Hi Frank/Alkesh,

Please refer below mentioned article to use QODBC with Crystal Reports:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/1565/76/how-to-use-qodbc-with-crystal-reports

http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2515
Ricky Sanchez
15 July 2014 03:11 PM
Im running and old QB POS 2.0 version in a win Xp Pro C PU in a network of 3 CPU. I can open the POS fromo CPU #2 and #3 but when I try to open it from #1, where the data file is stored and is the main CPU, it wont open and it say's "ERROR READIN G SECURITY FILE". Can You help me to solved this problem please?
Jack
03 September 2014 09:54 AM
Hi Ricky,

There might be something related to Windows Security which is causing the issue. I kindly request you to please check windows security.

I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

I kindly request you to share more information about the issue you’re facing, so that we can locate the problem quickly.

We may need following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC POS Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC POS Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC POS Setup Screen -- > Messages -- > Review SDK Messages

Larry Williams
14 August 2014 09:31 AM
Running QB Enterprise 14 on server 2008 R2 Using terminal services. Getting UAC error whenever attempting connection. Is there something special required for this configuration?
Jack
03 September 2014 10:58 AM
Hi Larry,

I would like to inform you that Test Connection may fail If it's executed as an Admin user. I kindly request you to please make sure that you are running QuickBooks & QODBC both in same user context (i.e. Both applications either should be run as contexted user or both apps should be run as Admin user).

If both applications are run in different user context, then you may face this issue. I kindly request you to please verify the same & test connection through VB Demo.
Joel Szirtes
02 August 2015 06:31 AM
I have experienced the same incidents as everyone above. I could not trouble shoot these errors:

"UAC Off or Running as Elevated ("Run As Administrator")

Please contact me.

Jack
05 August 2015 10:20 AM
Hi Joel,

I would like to inform you that Test Connection may fail If it's executed as an Admin user. I kindly request you to please make sure that you are running QuickBooks & QODBC both in same user context (i.e. Both applications either should be run as contexted user or both apps should be run as Admin user).

If both applications are run in different user context, then you may face this issue. I kindly request you to please verify the same & test connection through VB Demo.

Please refer:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2512
Kevin Whiting
18 February 2016 05:15 AM
Having trouble connecting to Reckon Accounts (Aust version of QuickBooks). Cannot connect with VB Demo. If file is open, get #80040408 "Could not start Reckon" and QODBC does not appear in Integrated Applications list. If file is closed, get #80040430 "Unable to log in". Using Windows 10 - any known issues?
Jack
18 February 2016 07:34 AM
Hi Kevin,


The error 80040430 says that you have not accepted QuickBooks certificate. I kindly request you to please keep QuickBooks running, logged in as Admin to your company file, Switch to single user mode and try to connect using your application, it should pop-up Data Access Certificate on QuickBooks, Please accept the Certificate Then try again.

I would like to inform you that QuickBooks issue Certificate is for each application. You might have accepted the certificate for application A, but application B would not have access.

Please refer:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2147/59/troubleshooting-begin-session-failed-error--8004041d-80040418-8004041a-80040430

We kindly suggest you to try Keeping QuickBooks running, logged in as Admin & try to test the connection using VB Demo application.Your QuickBooks file should be accessible and should not be in the restricted folder.

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 Setup Screen once it has passed connect via VB Demo.

Please refer:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2512
If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
James Crowhurst
12 May 2016 12:37 AM
I have tried both running as a standard user and as admin in Windows 7. Quickbooks recognizes QODBC and will open it up to setup the ODBC. The "Test Connections to Quickbooks" fails every time. It s setup as the standard setup. I have noticed, though, that during the install of QODBC it had a partial failure and after I chose ReInstall, there were no more warnings.

Does QODBC work on Windows 7??
Jack
12 May 2016 07:23 AM
Hi James,

I would like to inform you that Test Connection may fail If it's executed as an Admin user. I kindly request you to please make sure that you are running QuickBooks & QODBC both in same user context (i.e. Both applications either should be run as contexted user or both apps should be run as Admin user).

If both applications are run in different user context, then you may face this issue. I kindly request you to please verify the same & test connection through VB Demo.

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 Setup Screen once it has passed connect via VB Demo.

Please refer:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2512

If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Jorge
04 June 2018 02:41 PM
I updated to version 18 and start giving the error 653. is version 18 compatible with windows 10? I have tried all the suggestions from knowledge base and nothing works..

Thank you in advance for your assistance
Rajendra Dewani
28 February 2019 01:51 PM
I would suggest uninstalling the current version of QODBC and installing the latest version of QODBC. QODBC 18 is compatible with Windows 10. If you are still facing the issue. Please raise a support ticket with us. Regards -Raj - QODBC Support
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).