ODP.NET Typed Dataset

All replies

• 

  

  0

  Sign in to vote

  Hello RK9.

  Thanks for your post.

  I think you could follow the steps as below:

  1. From your windows program menu, start Visual Studio. In Visual Studio, from View menu select Server Explorer.

  2. Right click Data Connections and select Add Connection from the menu. An Add Connection dialog box opens.

  3. In the Add Connection dialog box, ensure the Data Source is set to Oracle Database Server (Oracle ODP.NET).

  In the Add Connection dialog box, ensure the Data Source is set to Oracle Database Server (Oracle ODP.NET).   Note: If the Data Source is not set to Oracle Database Server (Oracle ODP.NET), click "Change" to select the appropriate data source and the data source provider. In the Change Data Source dialog box, select Oracle Database Server from the Data Source list and select Oracle Data Provider for .NET from the Data Provider drop down list. Click OK. Because I don't have Oracle DataBase, I can't repro your issue. I quoted the steps from http://social.msdn.microsoft.com/Forums/en/adodotnetdataset/thread/e438f930-975e-4057-9279-2a688804ebb0 I hope this can help you.   have a nice day,

  ---

  ---

  Jackie Sun [MSFT]
  MSDN Community Support | Feedback to us
  Get or Request Code Sample from Microsoft
  Please remember to mark the replies as answers if they help and unmark them if they provide no help.
  
  

  Monday, June 13, 2011 7:59 AM
• 

  

  0

  Sign in to vote

  Hi,

  I understand your steps but here the problem is it is not displaying the Oracle Database Server (Oracle ODP.NET) in dropdown list.My question is what makes to dispaly the ODP.NET provider into the dropdown list?

  Wednesday, June 15, 2011 4:05 AM
• 

  

  0

  Sign in to vote

  Hi again,

  Does your Oracle version match your OS? For example: your OS is 64 bits, however, your Oracle just supports 32 bits. Or something else...If so, here is an link for 64 bits Windows: Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64)

  Not sure this is the reason, for better support, please post in the Oracle Forum: http://forums.oracle.com/forums/main.jspa;jsessionid=8d92079330d6f3abac15bd09435bb9cd975c3e464585.e38QbNuQbx8Kbi0LbhaMaxuPaxn0?categoryID=84

  I hope this can help.

   

  have a nice day,

  ---

  Jackie Sun [MSFT]
  MSDN Community Support | Feedback to us
  Get or Request Code Sample from Microsoft
  Please remember to mark the replies as answers if they help and unmark them if they provide no help.
  
  

  • Proposed as answer by Jackie-Sun Tuesday, June 21, 2011 5:09 AM

  Thursday, June 16, 2011 3:15 AM