Coldfusion login problem

Question

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 Answer

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,

^ _ ^

Dave Watts · Answer

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

Error Executing Database Query.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Error
Executing Database Query.