Troubleshooting: Unable to connect to QuickBooks using QODBC. QODBC Freeze, QODBC Hangs, QODBC stuck during connection.

Problem Description 1:

I have the latest driver version and no errors during installation. When I try to connect, it just stuck "connecting"

Problem Description 2:

We installed the trial QODBC for the workstation. We cannot connect to our company file using ‘test connection’. QODBC and QuickBooks hang, but can be closed with task manager.

Problem Description 3:

The QODBC driver passes the Test Connection to QuickBooks after the initial install.

Shortly after the initial install stops working.
The Test Connection to QuickBooks button just hangs.
The screen says Not Responding
Hangs until the task is killed.

Solution:

Please follow below listed steps.

1) Remove Optimizer file(s)

Click the Windows Start button >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source Go To "System DSN" Tab, select "QuickBooks Data" DSN & click "Configure" Switch to Optimizer tab & Click Reset Optimizer File(s)

You may also refer How to Remove Optimizer file.


2) Please verify that the Optimizer File(s) are deleted.

You can find optimizer folder path from QODBC Setup Screen-> “Optimizer” tab.

The default path: "%appdata%\QODBC Driver for QuickBooks\Optimizer".
For Example: C:\Users\YOURNAME\AppData\Roaming\QODBC Driver for QuickBooks\Optimizer.

3) Please enable QODBC status panel

Click the Windows Start button >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source >> Go To "System DSN" Tab, select "QuickBooks Data" DSN & click "Configure" >> Navigate to Message tab->Select "Display Driver Status" and "Display optimizer Status" options.

You may also refer How to view details on what QODBC is performing / Display Driver Status / Display optimizer Status.

4) Please try to connect to QuickBooks using QODBC Support Wizard. 

5) Optional - Rebuild the Optimizer file(s)
For more details, please click here. Refer to the section "Rebuild Optimizer file"

(Skip the Step 1 and follow all the steps from -  Step 2)