?
Solved

oracle.dataaccess.client not recognized in web.config

Posted on 2011-04-26
8
Medium Priority
?
2,716 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

0
Comment
Question by:ODOTServer
  • 5
  • 3
8 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 35468802
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
0
 
LVL 48

Expert Comment

by:schwertner
ID: 35468811
0
 

Author Comment

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

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:ODOTServer
ID: 35469109
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.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 35469486
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
0
 

Author Comment

by:ODOTServer
ID: 35469670
Yes it is populated. I have run sqlplus and several PL/SQL developer tools from the Oracle Home that contains ODAC.
0
 

Accepted Solution

by:
ODOTServer earned 0 total points
ID: 35882606
Ignored error in web.config and stored procedures are working.
0
 

Author Closing Comment

by:ODOTServer
ID: 35910046
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.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question