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, Test Connection 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 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 setup must be run without "Run As Administrator" and UAC must be turned on to Test the connection.

 

Solutions:

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

Follow 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
 

FYI: 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.

Alternative

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. )

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

If 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 could not find it, please refer 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 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.

 

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 on the QuickBooks machine

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

Solution:

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.

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

I kindly request you to please try to test the connection using VB Demo application. 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:

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


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

Accessing QuickBooks Data Remotely using QODBC & QRemote


If you are able to connect through VB Demo, then 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 Greyed/Disabled

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

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

Even though
(21 vote(s))
Helpful
Not helpful

Comments (20)
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
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).