[QODBC-Desktop] QODBC hangs on connecting. QODBC is stuck and not able to connect.
Posted by Rajendra Dewani (QODBC Support) on 31 October 2018 09:50 AM
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.
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)
The default path: "%appdata%\QODBC Driver for QuickBooks\Optimizer".
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.
5) Optional - Rebuild the Optimizer file(s)
(Skip the Step 1 and follow all the steps from - Step 2)