We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

oracle.dataaccess.client not recognized in web.config

Medium Priority
3,376 Views
Last Modified: 2012-05-11
I have loaded the latest Oracle ODP for .net 11.2.0.2.30 beta.
I am using Visual Studio 2010 with sp1.

I am trying to define stored procedure metadata in the webconfig file per Oracle documentation but the compiler does not recognize the entries for the oracle.dataaccess.client in the webconfig file for my application.

This latest ODAC has been imported in my application and the ODAC path is the first registered in my enviromental variables.

I receive the following compilation warning:
Could not find schema information for the element 'oracle.dataaccess.client'.      

So anyone have an idea please send it my way.
<configuration>
  <connectionStrings>
    
   <add name="OracleEntities" connectionString="metadata=res://*/Models.OracleModel.csdl|res://*/Models.OracleModel.ssdl|res://*/Models.OracleModel.msl;provider=Oracle.DataAccess.Client;provider connection string=&quot;&#xD;&#xA;
     DATA SOURCE=MySource;PASSWORD=MyPassword;PERSIST SECURITY INFO=True;USER ID=MyUser&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
 
  <oracle.dataaccess.client>  #ERRORS here
    <settings>
      <add name="DllPath" value="C:\ODAC\product\11.2.0\client_1\bin"/>
      <add name="FetchSize" value="131072"/>
      <add name="StatementCacheSize" value="100"/>
    </settings>
  </oracle.dataaccess.client>
  
  ...
  </configuration>

Open in new window

Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008

Commented:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;

With some data:

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=156.34.568.24)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=myUsername;Password=myPassword;

So the most important is to figure out in advance:

HOST
PORT
SERVICE_NAME
userName
userpassword
CERTIFIED EXPERT
Top Expert 2008

Commented:

Author

Commented:
My tnsnames are setup correctly.
The entity framework is using it currently to connect and model the database.

Author

Commented:
This acts as if I need another schema element prior to <oracle.dataaccess.client> in the root webconfig file of my project.

Similar to what happens when a library is missing and you call a class from that library.

Intellisense doesn't work etc. However, ODAC is referenced in the project.
CERTIFIED EXPERT
Top Expert 2008

Commented:
Could you check if there are the needed dlls in C:\ODAC\product\11.2.0\client_1\bin
Normaly in ...\bin are placed .exe and .com

Author

Commented:
Yes it is populated. I have run sqlplus and several PL/SQL developer tools from the Oracle Home that contains ODAC.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
The warning message issued is arbitrary. I learned from a .Net product manager in oracle that this can be ignored because it has no ill-effects on the solution. Continued coding and as he specified, the result sets were returned.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.