Accessing Oracle databases in Visual C# .Net Express

Can someone please show me / tell me how to connect to an oracle database with Visual C# .Net Express...

I have an Oracle 9i databse and I have the 10g client installed. This works fine in Visual Studio .Net 2003 but I can't connect at all in Express. Is it something to do with the .Net Framework 2.0

Any help much appreciated as I'm a complete novice to C# ... I'm a VB programmer by trade ( and VB 6 at that )...

 

Elton




Answer this question

Accessing Oracle databases in Visual C# .Net Express

  • Kitek

    Further to this I get the following error when trying to access the connectionstring property of the connection object:

    Data provider identified by guid '00000000-0000-0000-0000-000000000000' could not be loaded.

     



  • Ettore

    I think one of the main limitations of the express editions is the inability to access data sources using the data controls.

    After all why would Microsoft allow you to do this and then attempt to sell you a product which you dont need (Apart from the obvious licencing issues)


  • Jyri Hujanen

    Thanks very much guys.... I'm still waiting for my company to purchase VS.Net 2005.

  • Liz____9

    Hmmmm. OK I can access the data programatically via ado.net commands but I can't use the built-in controls (connection, adapter etc).

  • cdaniele

    That's correct.  One of the limitations of the Visual Studio Express products, to keep the tool simple, is that you can only work with local databases using the built-in designer tools.

    As you noticed, it is still possible to work with other databases programmatically.

    Thansk,
    Luke Hoban
    Visual C# IDE Program Manager

     

     


  • Accessing Oracle databases in Visual C# .Net Express