Devart Forums

How is it possible to connect to an oracle database via proxy authentication using 'dotConnect for Oracle 6.80 Mobile' ?

In your 'dotConnect for Oracle Features' List this feature is listed on 'Network and connectivity'
... * Proxy Authentication support *...

I tried this connection string:
"User Id=ProxyUser[test_user];Password=ProxyPW;Server=172.16.2.105;Port=1523;Service Name=OraTest.Bss;"

... and got an exception: "ORA-01017: invalid username/password; logon denied"

this syntax works fine with sqlplus.

My next try was to change the connection string to:
"User Id=test_user;Oci Session Pool User Id=ProxyUser;Oci Session Pool Password=ProxyPW;Server=172.16.2.105;Port=1523;Service Name=OraTest.Bss;"

But this also ends with an exception -> System.NotSupportedException ...


In your Documentation I found this hint:
Opens connection with Proxy Authentication mechanism.

[C#]
public void Open(
OracleConnection proxy
);

But this overload doesn't exist in mobile Version.

Thanks

Proxy authentication (via both OCI session pooling and conn.Open(conn2)) is not supported in the Direct mode which is used by Mobile Edition. It is available only in the OCI mode (via Oracle client) when using the desktop version of dotConnect for Oracle.