Network data encryption works between managed ODP.NET and non-Windows DB servers. The confusion in the doc is likely due to the discussion of NTS authentication adapter next to the encryption section without a clear indicator that the subject matter changed. That doc issue will be fixed in the next revision.
Thanks Alex for your quick answer. However it doesn't seem to work in my environment cause as soon as I toggle on encryption on the server (AIX) then I'm having error ORA-12537: Network Session: End of file from my web api application. Here is what I have in my web.config client application :
<dataSource alias="TheDataSource" descriptor=" (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = serverName)(PORT = 1551))(CONNECT_DATA = (SERVICE_NAME = serviceName))) " />
<setting name="SQLNET.ENCRYPTION_CLIENT" value="ACCEPTED"/>
<setting name="SQLNET.ENCRYPTION_TYPES_CLIENT" value="AES256"/>
<add name="IvrDbContext" connectionString="DATA SOURCE=TheDataSource;PASSWORD=whatever;PERSIST SECURITY INFO=True;USER ID=whatever" providerName="Oracle.ManagedDataAccess.Client" />
On the server side, my db admin added those lines :
Am I missing anything ?
1 person found this helpful
Turn "off" checksumming on the server side and try to connect again. That is likely causing the problem. Checksumming is not supported until the upcoming April managed ODP.NET patch release. At that point, you will be able to use checksumming with managed ODP.NET.
That works fine. Thanks for your valuable help.