Hi Oracle forum,
I am unsuccessfully trying to migrate a C# solution to use oracle.manageddataaccess instead of oracle.dataaccess libraries.
For testing purpose, I have selected one connection to a database alias as DAMDP in tnsnames.ora.
With Oracle.manageddataaccess I can:
- Connect to the database directly via the descriptor: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora_damdp)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DAMDP)(SERVER=DEDICATED)))
- Use the alias IF the .ora file and corresponding sqlnet.ora file are in the bin directory of my .exe file.
However, whenever I try to configure app.config to programmatically reference the datasource or the TNS_ADMIN, my connections fail.
I get the following error: "ORA-12154: TNS:could not resolve the connect identifier specified".
Configuration:
<oracle.manageddataaccess.client>
<version number="*">
<dataSources>
dataSource alias="DAMDP" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora_damdp)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DAMDP)(SERVER=DEDICATED))) "/>
</dataSources>
<settings>
<setting name="TNS_ADMIN" value="C:\Oracle\product\11.2.0\client_1\network\admin"/>
</settings>
</version>
</oracle.manageddataaccess.client>
The content of my sqlnet.ora file:
names.default_domain = world
automatic_ipc = off
trace_level_client = off
Sqlnet.Authentication_Services=(BEQ,kerberos5,NONE)
names.directory_path = (TNSNAMES)
SQLNET.KERBEROS5_CC_NAME = OSMSFT://
SQLNET.KERBEROS5_CONF = C:\Oracle\product\11.2.0\client_1\network\ADMIN\krb5.conf
SQLNET.KERBEROS5_CONF_MIT = TRUE
Possibly important information also, whenever I compile my project i get the following messages:
Message 1 Could not find schema information for the element 'oracle.manageddataaccess.client'
I have tried to add a schema for oracle.manageddataaccess.client but it does not fix my issue.
I would really appreciate the help Thank you,
Pierre-Jean