Oracle database

  • Thread starter Thread starter Baccarin
  • Start date Start date
B

Baccarin

Hi all,

I would like to obtain opinions about which is the best
way to get access to Oracle databases from C#
applications: oledb, ODBC.NET, etc. Any comment or
information will be very useful.

Regards,

Baccarin.
 
Hi all,

I would like to obtain opinions about which is the best
way to get access to Oracle databases from C#
applications: oledb, ODBC.NET, etc. Any comment or
information will be very useful.

Regards,

Baccarin.
Click to expand...
ODP.NET from Oracle's site, in my opinion. It does require that you
install the Oracle 9.2 client, which might be an issue for some
people.
 
My recommendation would be to use the Microsoft Managed
Provider for Oracle, which is included with VS.Net 2003 or
can be downloaded from msdn.microsoft.com for use with
VS.Net 2002. This provider gives you access to oracle
data types and features which you cannot access through
ODBC or OLEDB.

An alternative is the Oracle managed provider (which you
can download from otn.oracle.com), but my experience is
that the Oracle drivers are more buggy than the Microsoft
ones. Also, the Oracle offering is 47Mb in size as
opposed to the Microsoft one which is about 1Mb.

Regards,
Neil.
 
The best resource I have seen on using Oracle from .net is Bob Beauchemin's
excelent article on Visual Studio Magazine
http://www.fawcette.com/vsm/2003_01/magazine/features/beauchemin/

I highly recomend reading through it, allthough it is now slightly out of
date. The microsoft Oracle managed provider v1.1 is now integrated with
visual studio and I believe that we have done well in terms of performance,
scalability and support of Oracle features I would highly recomend it over
older Oledb or Odbc solutions. Two other solutions you may want to
investigate are Oracles ODP.net and Merants oracle driver
 
Hello,

I am new to the Visual Studio .NET and am trying to use the ODP .NET
software to connect to my Oracle9i DB. I am confused however. How do I
make a connection within the Server Explorer in Visual Studio?

When I try to create one I don't have the ODP.NET as an option; only
Microsoft drivers are shown.

Is this something thats even possible?

TIA,

Jeff Reed
 
Jeff,

The server explorer is still based on OLEDB (recognize those dialogs from
VB6?) and so only OLEDB connections can be created. Visual Studio appears
to have a hack in it such that OLEDB Connections to SQL Server are converted
to use the SQLClient Managed provider when you drag and drop from server
explorer. Likewise, in VS.net2003 an Oracle OLEDB connection is translated
to use the OracleClient managed objects.

However, when you drag and drop a connection to a SQLServer 6.5 database it
still uses the SqlClient objects, which don't work with SQL6.5, so it's not
quite seamless. Also, you can't create OLEDB connections to Oracle or SQL
Server by drag and drop.

Neil.
 
Hello,

I am new to the Visual Studio .NET and am trying to use the ODP .NET
software to connect to my Oracle9i DB. I am confused however. How do I
make a connection within the Server Explorer in Visual Studio?

When I try to create one I don't have the ODP.NET as an option; only
Microsoft drivers are shown.

Is this something thats even possible?

TIA,

Jeff Reed
Click to expand...
You can't do this from server explorer. You can add the oracle objects
to the tool palette and add them from there.

Personally I wouldn't bother. Create a class module and do your
connections there. Take a look at Microsoft Data Access Application
Blocks. You won't find one for ODP.NET but the principles are good.
There is an ODP.NET version being worked on independently, search the
forum on the Oracle web site and you'll find some links.
 
Back
Top