Troubleshooting - QODBC Auto-connecting with the Wrong User
Problem Description:
We have a few stations where we utilize the read-only QODBC desktop version. On a station that we just built, it keeps to 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.
Solutions:
Please remove all the integrated applications via:
QuickBooks UI -> Edit -> Preferences -> Integrated Applications -> Company Preferences and re-connect QODBC again to see if it can solve the issue.
Please Refer:
How to remove QODBC Related Certificates from Integrated Application Under QuickBooks
Please Note: If QuickBooks is running and a user is logged in, user specified in the Integration will be ignored and currently logged in user on QuickBooks will be used.
When QuickBooks is not running and you try to connect using QODBC auto login, then it will login to QuickBooks with the user that has been selected in the Integration settings in the QuickBooks file. But when QuickBooks is running and you try to connect using QODBC auto login, then it will login to QuickBooks with the user which is logged in the QuickBooks file.
|