proxy authentication on dotConnect for Oracle Mobile

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
dt-developers.bss
Posts: 1
Joined: Mon 23 Apr 2012 11:19

proxy authentication on dotConnect for Oracle Mobile

Post by dt-developers.bss » Mon 23 Apr 2012 12:15

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 27 Apr 2012 08:22

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.

Post Reply