After switch to Oracle 11g: invalid username/password
Posted: Wed 24 Sep 2014 07:11
Hi,
Two of our customers experience problems accessing their database after switching from Oracle 10 to 11. We use ODAC 8.6.12.
SEC_CASE_SENSITIVE_LOGON is set to false.
There is no problem logging on from SQLPlus.
Logon works fine with our current software on Oracle 10, but doesn't work on 11 (for these customers, who switched their database from 10 to 11).
Logon to the Oracle 11 database also works fine with an older version of our software (I unfortunately don't know which version of ODAC was used for that).
Our connecting code looks something like this:
One of the customers has switched to a client connection, which does work.
Any suggestions?
Thanks, regards,
Miel.
Two of our customers experience problems accessing their database after switching from Oracle 10 to 11. We use ODAC 8.6.12.
SEC_CASE_SENSITIVE_LOGON is set to false.
There is no problem logging on from SQLPlus.
Logon works fine with our current software on Oracle 10, but doesn't work on 11 (for these customers, who switched their database from 10 to 11).
Logon to the Oracle 11 database also works fine with an older version of our software (I unfortunately don't know which version of ODAC was used for that).
Our connecting code looks something like this:
Code: Select all
OraSession.Options.Net := True;
OraSession.Server := '127.0.0.1:1521:XE';
OraSession.UserName := 'user';
OraSession.Password := 'passwd';
OraSession.Connected := True;
Any suggestions?
Thanks, regards,
Miel.