I have a console application which is trying to connect to an Oracle DB(in a different server) using Oracle Managed Data Access dll (Oracle.ManagedDataAccess.dll 12.2 version). The server that this console application is being executed in, does not have oracle installed, which means there are no tnsnames.ora, sqlnet.ora files as well. I am able to successfully access the db and retrieve the records by specifying the DataSource with the Credentials (User Id and Password).
However, while trying to access the same DB with Wallets, it fails giving ORA-01017: Invalid Username/Password logon denied error.
The app.config configuration is as follows:
<configuration>
<configSections>
<section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</configSections>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7" />
</startup>
<oracle.manageddataaccess.client>
<version number="*">
<settings>
<setting name="SQLNET.WALLET_OVERRIDE" value="TRUE"/>
<setting name="WALLET_LOCATION" value="(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=D:\wallet_location)))"/>
</settings>
</version>
</oracle.manageddataaccess.client>
<connectionStrings>
<add name="OracleSessionState" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=yyyy.yyy.com)));User Id=[some_user_id]; Validate Connection=true;" providerName="Oracle.ManagedDataAccess.Client" />
</connectionStrings>
</configuration>
We also tried using the settings (SSL_VERSION:1.0, 1.2, 3.0) , SQLNET.AUTHENTICATION_SERVICES but nothing worked.
Am i missing something here, please advice.
Regards,
vinod