I need to connect with Oracal database ..what are the states for that ? RRS feed

  • Question

  • hi...

    I need to connect with Oracal database ..what are the states for that ? 

    and also

    I don't have ODP.Net...where can i download it ?

    Saturday, August 18, 2012 7:19 AM


All replies

  • Easiest way to connect to Oracle database is use ADO.NET provider from Oracle, download developer tools to Visual Studio. If for some reason you don't want to use that, you can use OleDbCommand class included in System.Data.OleDb namespace in .NET Framework.

    Connecting is easy as using any other ADO.NET provider.

    Saturday, August 18, 2012 5:42 PM
  • Hi .netaholic,

    If you just haven't used ODP.Net before, I suggest you to read the oracle document:

    Getting Started with Oracle Data Provider for .NET (C# Version)

    Best Regards,This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Bob Wu [MSFT]
    MSDN Community Support | Feedback to us

    Tuesday, August 21, 2012 6:30 AM
  • Just to add that Oracle's provider requires a matching Oracle client installed (a ton of megabytes). There is a commercial option from DevArt that is a standalone lightweight product - copy & paste deployment, no version problems, etc.

    Miha Markic [MVP C#]

    Tuesday, August 21, 2012 6:55 AM