[QODBC-Desktop] Connection Lost between QODBC and QuickBooks. QuickBooks Asking for Password
Posted by Juliet (QODBC Support) on 25 July 2011 06:40 AM
Troubleshooting: Connection Lost between QODBC and QuickBooks / QuickBooks asking for password even though Certificate is accepted.
We might get an issue where every time we reboot our file server the connection between QODBC and QuickBooks needs to be reconfigured. We have to go and grant QODBC rights to allow to log in automatically as admin under the Integrated Applications section in QuickBooks. We have to do this for each company file. Is there a reason why this connection breaks anytime we reboot the server? Is there a way to correct this issue?
Please follow the steps below to fix that:
1. Try removing all the integrated application entries in QuickBooks again via Edit Menu -> Preferences -> Integrated Applications -> Company Preferences Tab.
2. Exit QuickBooks.
3. Locate the company file name.lgb/company file name.sds and delete it. You can find the company file name.lgb/company file name. sds from the location where you store company files.
Note: You could keep a backup of the "company file name. lgb"/"company file name. sds" so that if you want to use the old file you revert back quickly.
4. Open QuickBooks again, connect once with VBDemo Or your application, then try connecting again with QuickBooks closed.
5. Accept the Certificate.
Associate a QuickBooks User to auto-login to the company file [If you are using Auto login]. See also: How to set up QODBC for Auto-login into QuickBooks for more.
Note: This is a QuickBooks issue, not necessarily anything wrong with QODBC. The .lgb file is fragile, and deleting it will usually repair it.