@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?