eWallet .NET

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
spinriko
Posts: 2
Joined: Thu 26 Apr 2012 00:05

eWallet .NET

Post by spinriko » Thu 26 Apr 2012 00:17

I can connect via SQLPlus using the TNS_ADMIN env var which holds the location of an eWallet credential. But, I can't make this work using a connection string in my WCF application.

If I set Direct=true, dotConnect looks for all required elements in the connection string; if I set it false, it uses ORACLE_HOME. Any way to have the provider recognize TNS_ADMIN so eWallet can be used?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: eWallet .NET

Post by Pinturiccio » Mon 07 May 2012 14:30

Could you please tell us how you create and use eWallet with TNS_ADMIN? We would appreciate direct references to the documentation concerning this topic. Looking forward to your reply.

spinriko
Posts: 2
Joined: Thu 26 Apr 2012 00:05

Re: eWallet .NET

Post by spinriko » Tue 08 May 2012 00:43

we use
mkstore -wrl `pwd` -createCredential command to create the credential.


setenv TNS_ADMIN /network_path/wallet/unix

contents of sqlnet.ora

DIAG_ADR_ENABLED=OFF

WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /network_path/wallet)
)
)

SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: eWallet .NET

Post by Pinturiccio » Fri 11 May 2012 07:22

Are the tnsnames.ora and sqlnet.ora files in the same place as eWallet? Note that Oracle Client uses the TNS_ADMIN variable regardless of using our provider. In Direct mode the TNS_ADMIN variable is not supported.

Post Reply