Coldfusion login problem

[iq11]

Hello,

  When I try to use the login page to go to my Application, I get the following error. I have already checked my username and password , they are correct.

We are using Oracle 11g database and Cold fusion 9. Please help ?

"

Error Executing Database Query.

[Macromedia][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied

Please try the following

"

Thanks

IQ

[WolfShade · Accepted solution]

Are you storing the password in clear text (ie, not encrypted)?  If you are, that's generally not safe.  But double-check in the database to make sure the password is correct.  I know that in Oracle the default setting is to enforce CaSe-SeNsItIvE SELECTs.  Even a space could make a difference.

If you are encrypting the password, I'd guess that the key may be incorrect.  Try generating a new key, and update the database with a refreshed version.

Ignore all that.  LOL!  The issue isn't your login/pw for your app.. it's the login/pw for your DATABASE account.  CF cannot access the database.

HTH,

^ _ ^

[iq11]

This is exactly the issue, resetting the password fixed the issue.

[WolfShade]

Thank you for marking my answer as correct.  I do appreciate it.

V/r,

^ _ ^

[Sunny_art15D5]

Typically, this means that you've entered incorrect values in the CF Administrator for your data source. But on another topic, you really shouldn't be using CF 9 any more. It's very old and not really suitable for use any more.

Dave Watts, Fig Leaf Software