Check in and Check out error or Username /Password Error while logging into Local databases

We often face the username or password error while logging into local Siebel tools or client, even though we have correct credentials. This normally happens from the ODBC level, i.e. you might have tried to test the connection from ODBC with a different username and password and forgot to clear it from the corresponding odbc connection.  This leads to either Check out or check in Error or it will throw error while logging in if the credentials used in ODBC not exists in this local database. 

In this example you can see, say first scenario, I am using USER as username and at odbc level I have tested connection with SADMIN and not cleared the credentials. In such cases, if I have right credentials at odbc level it will allow you to login, but with credentials at ODBC level, not with the username or password you have entered at login screen.

.

In the second scenario, if you were able to login with the credentials at ODBC level and when you try to do the check out or check in you will face error of repository conflict or username conflict as its not the same user you usually do the check in/out with server.