Hi!
I'm using VS.Net 2019 to build a simple single webpage (*.aspx) that connects to my Oracle database using ODP.Net (Oracle.ManagedDataAccess, Version=4.122.18.3) over port 2484 and protocol TCPS.
The database is located in another server, not my dev box, and is ready for TCPS. The certificate is already installed in MCS in my dev box.
The certificate is stored in MCS in these locations:
Local Computer\Trusted Root Certification Authorities = LocalMachine\Root
Local Computer\Personal = LocalMachine\My
Current User\Trusted Root Certification Authorities = CurrentUser\Root
Current User\Personal = CurrentUser\My
My simple web application is connecting fine to the database when I run it from VS.Net 2019 (IISExpress) using these settings:
<oracle.manageddataaccess.client>
<version number="*">
<settings>
<setting name="WALLET_LOCATION" value="(SOURCE = (METHOD = MCS))" />
<setting name="TraceLevel" value="7" />
<setting name="TraceOption" value="1" />
<setting name="TraceFileLocation" value="C:\trace" />
</settings>
</version>
</oracle.manageddataaccess.client>
And connection string is:
<add name="DBConnString" connectionString="USER ID={user};PASSWORD={password};DATA SOURCE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST={host ip})(PORT=2484)))(CONNECT_DATA = (SID = {sid})))) " />
But when I deploy the app to my local IIS (dev box is Windows 10 and IIS version is 10.0.17134.1 (WinBuild.160101.0800)) and navigate to the webpage.aspx the connection cannot be established.
The error message is "Network Transport: SSL failure in parsing wallet location".
Where should the certificate be stored for Wallet METHOD=MCS in IIS? Am I missing an ODP.Net setting to make this work?