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 a 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 contain an un-appropriate system setup change from a regular 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 QODBC Test Tool to perform a test connection.

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

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

With UAC off:

     (1) Login as Administrator

     (2) Start -> Control Panel -> User Account -> Open or Closen "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 following: (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 following: (The "Test Connection to QuickBooks" button is lighted)

    If you can still not get the "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 the test connection succeeds, you can get data from QuickBooks.

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

Use QODBC Test Tool 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.

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