proxy authentication on dotConnect for Oracle Mobile

proxy authentication on dotConnect for Oracle Mobile

Postby 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
dt-developers.bss
 
Posts: 1
Joined: Mon 23 Apr 2012 11:19

Postby 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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle