After switch to Oracle 11g: invalid username/password

[embronne]

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:

Code: Select all

  OraSession.Options.Net := True;
  OraSession.Server := '127.0.0.1:1521:XE';
  OraSession.UserName := 'user';
  OraSession.Password := 'passwd';
  OraSession.Connected := True;

One of the customers has switched to a client connection, which does work.

Any suggestions?

Thanks, regards,

Miel.

[AlexP]

Hello,

This problem is due to the fact, that since Oracle 11.2.0.4, server access protocol was changed. We have already supported this protocol in ODAC 9.4.11. Please download the latest ODAC version, check connection again.