Skip to Main Content

General Development Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I use UNC for Wallet_location?

user-jlm81Feb 24 2023 — edited Feb 24 2023

@alex-keh-oracle ,

I have compiled a local executable Winforms app which is an Oracle “thick” client. I do not wish to change the code within it.

When I change my connection string by removing the password, setting the USER_ID = /, and implementing a local C:\ located wallet pointing at our on-site 19c database, I can connect just fine. If I have set my TNS_ADMIN environment variable, I do not even need to specify the WALLET_LOCATION or the TNS_ADMIN in the connection string.

DATA SOURCE=MYDB;USER ID=/;

The C:\users\public\tns\sqlnet.ora file is

sqlnet.authentication_services=(NTS)
SSL_CLIENT_AUTHENTICATION = FALSE
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = c:\users\public\tns)
)
)

SQLNET.WALLET_OVERRIDE = TRUE
SSL_VERSION = 0

However, when I relocate the wallet to \\Unc\path as shown here . . .

Connection String:

WALLET_LOCATION=\\Unc\path;TNS_ADMIN=\\Unc\path;DATA SOURCE=MYDB;USER ID=/;

(and of course I changed the sqlnet.ora directory as well)

. . . I get an error:

Error: “Login failed: Network Transport: SSL failure in parsing wallet location”.

I see an answer in another thread of yours stating that one must set ProcessStartInfo.LoadUserProfile=True in order to use a local wallet, but I do not know how to implement this change in the app.config file.

How do I do this?

Must I distribute a local wallet to every one of my 100+ client workstations which run the Winforms app?

Comments
Post Details
Added on Feb 24 2023
0 comments
402 views