Knowledgebase: Connection
[QODBC-Desktop] Test Connection Button On QODBC Setup Is Grayed/Disabled
Posted by Rajendra Dewani (QODBC Support) on 23 August 2012 10:34 AM

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

The QODBC Driver for QuickBooks runs differently under Microsoft Vista/W7 than other versions of Windows because of its new strict security settings.

UAC (User Account Control): is new technology in Windows Vista onwards to improve system security which asks all users permission to run programs and tasks under a standard account module. It can prevent the installation of programs without authentication and can also prevent a un-appropriate change of the system setup from a standard user.

If a button is not available in QODBC, it means that you have forced Administrator rights. The setup must be run without "Run As Administrator" and UAC must be turned on to activate these buttons.

Follow below steps

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

  If Test Connection is enabled: You can perform a test connection or can use VB Demo to perform a test connection

FYI: Data Source Administrator ( which by default runs as "Run as Administrator" )

If above does not resolve the "Test Connection" Grayed out the issue, Please follow below steps.

With UAC off:

     (1) Login as Administrator

     (2) Start -> Control Panel -> User Account -> Open or Close“User Account Control”(UAC) -> uncheck Using User Account Control(UAC) to protect your computer”-> restart the computer

     (3) Run“OQDBC Setup Screen” and you will see the follows: (The“Test Connection to QuickBooks” button is gray and cannot be used.)

 

 With UAC on:

     (1) Login as Administrator.

     (2) Start -> Control Panel -> User Account -> Open or Close “User Account Control” (UAC) -> check “Using User Account Control(UAC) to protect your computer”

     (3) Run “OQDBC Setup Screen” and you will see the follows: (The“Test Connection to QuickBooks” button is lighted)

    In-case you are still unable to get "Test Connection" Button enabled, Close QODBC Setup Screen, Close Data Source Administrator ( if Open).

    Click Start -> All Programs -> QODBC Driver for use with QuickBooks -> QODBC Setup Screen

 

     (4) Click on the “Test Connection to QuickBooks” button and then make a certification for QODBC:

     When test connection succeeds, you can get data from QuickBooks.

 

In case even after setting the correct UAC, the button "Test Connection to QuickBooks" does not enable, You can still make a connection to QuickBooks.

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 thou  "Test Connection to QuickBooks" is not enabled.

 

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

(4 vote(s))
Helpful
Not helpful

Comments (6)
Bleng
20 September 2012 01:30 PM
Vista and UAC If you are looking to dilbase UAC for certain applications in Windows Vista, then follow this guide, and once you are done, the UAC may not really be all that bugging as it used to be. First download and install Application Compatibility Toolkit. Find
David Adress
26 February 2013 07:26 PM
I tried all this and my button is still disabled. Any ideas?
David C
27 August 2013 12:23 AM
What's this about?
I've tried installing demo versions of QuickBooks Premium and Reckon Accounts, for Australia, and I can't connect.
---------------------------
QODBC Test Connection
---------------------------
Test Connection to QuickBooks Failed

[QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.


Display an online list of connection errors and their resolutions?
---------------------------
Yes No
---------------------------
Jose Lopez
10 September 2013 01:36 PM
Eval on windows server. UAC off, but when testing connection gives an error "security issue". Please advise..
Rajendra Dewani
21 September 2013 07:51 AM
Connecting to QuickBooks failed because of a Windows security issue
Please refer :
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2507
Rajendra Dewani
21 September 2013 07:48 AM
Could Not Start QuickBooks :

I would suggest you to keep QuickBooks running, and try again.

I kindly suggest you to try Keeping QuickBooks running, logged in as Admin, single user mode.
Your QuickBooks file should be accessible and should not be in restricted folder.

Are you trying to run QODBC/QuickBooks in auto login? And is your machine having Terminal serviced/remote desktop enabled i.e. multiple user logging in to your machine using Remote desktop connection?"

If your Answer is No, Please make sure you are not running Your Application in evaluated user context , i.e. you should not run it as "Run as administrator" , Please share log files from QODBC Setup Screen -- Messages -- Review QODBC Messages & Review SDK Messages.

If your answer is yes, then I would like to inform you that QuickBooks SDK has a known limitation with this type of Environment setup and many time it cannot start the QuickBooks in background. (If more than one user is logged in to machine and QBW32.exe is running on more than one user account)

Workaround for the above issue.
1) Make sure you un-select the option of "Keep QuickBooks running for quick start-up" under QuickBooks -- Edit Preferences -- General.
Close all other QuickBooks instances of all other users and then try. (Please verify no instances are running of QBW32 under task manager --processes -- view all user processes)
OR
2) Keep QuickBooks running and try connectin1) Make sure you un-select the option of "Keep QuickBooks running for quick start-up" under QuickBooks -- Edit Preferences -- General.
Close all other QuickBooks instances of all other users and then try. (Please verify no instances are running of QBW32 under task manager --processes -- view all user processes)g.
OR
3) For QODBC 13.0.0.291 and upwards, under Advance tab, enable "Force Start QuickBooks", Make sure you un-select the option of "Keep QuickBooks running for quick start-up" under QuickBooks -- Edit Preferences -- General


If you are still facing issue, I kindly request you to create a support ticket and provided below listed files.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Log Files 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).