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 tried 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 the 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 hangs.
The screen says Not Responding
He hangs until the task is killed.

Solution:

Please follow the 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 the "System DSN" Tab, select "QuickBooks Data" DSN & click "Configure" Switch to the 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 the 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 the QODBC status panel

Click the Windows Start button >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source >> Go To the "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 to 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 section "3. Rebuild Optimizer file."