Knowledgebase: Setup
[QODBC-Desktop] Troubleshooting - QODBC Logging in with Wrong User account
Posted by Jack - QODBC Support on 23 May 2016 02:26 PM

Troubleshooting - QODBC Logging in with the Wrong User account

Problem Description:

I am using ms access. I have the integrated application certificate set up correctly (see screenshot). The username for this certificate is "odbc."



QuickBooks is closed.

Ms access file connects to QB via the connection string:

"ODBC;Driver={QODBC Driver for QuickBooks};DFQ=D:\QB\MyCompanyFile.qbw;OptimizerOn=No;IAppAutomaticLogin=n;OpenMode=F;OLE DB Services=-2;"

Connection works.

Another user tries to login in as "Admin" into QB on another computer, but it fails and says already logged in. See screenshot.



Why is QODBC using the "Admin" account?? I was expecting it to use the "odbc" account.

 

Solution:

You need to remove QODBC integrated application entries in QuickBooks & companyfilename. lgb and delete it to resolve the issue.

Please refer to Connection Lost Between QODBC and QuickBooks. QuickBooks Asking for Password for more details.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).