Troubleshooting - QODBC Auto-connecting with the Wrong User
We have a few stations where we utilize the read-only QODBC desktop version. On a station we just built, it keeps using the wrong QuickBooks user for the auto-login. I confirmed that the QuickBooks file is set to use the correct user for QODBC, and I also confirmed that our other stations are still connecting using the correct user; the issue is only with this one station.
QODBC seems to be otherwise working as expected. This isn't a usable state, however, as this station is reverting to a user with a different level of privileges on the system.
Please remove all the integrated applications via the following:
QuickBooks UI -> Edit -> Preferences -> Integrated Applications -> Company Preferences and re-connect QODBC again to see if it can solve the issue.
How to remove QODBC Related Certificates from Integrated Application Under QuickBooks
Please Note: If QuickBooks is running and a user is logged in, the user specified in the Integration will be ignored, and the currently logged-in users on QuickBooks will be used.
When QuickBooks is not running, and you try to connect using QODBC auto-login, it will log in to QuickBooks with the user selected in the Integration settings in the QuickBooks file. But when QuickBooks is running, and you try to connect using QODBC auto-login, it will log in to QuickBooks with the user logged in the QuickBooks file.