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?
eWallet .NET
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: eWallet .NET
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.
Re: eWallet .NET
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
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
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: eWallet .NET
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.