MSDAORA (Oracle)

[Ali]

Hey guys,

My customer wants me to use Oracle as a Data back end store. He's on board
with MS .net. I know MS said claims that they have an OLE DB provider for
Oracle, but I haven't used it much. Could you please tell me where I can
find more information on MSDAORA using ADO.NET not the old ADO stuff like
recordsets, etc...

Thanks,
Ali

[Bruce L-C]

You are a little confused. If you are familiar with ADO, in ADO you could
either use an OLEDB provider or an ODBC provider. ADO was based on OLEDB and
the way you could use ODBC is that MS came out with an OLEDB->ODBC provider
(essentially wrapping ODBC to be usable from OLEDB).

In ADO.Net you can use OLEDB providers. This allows using a generic API in
ADO.Net against multiple backends. The OLEDB Dotnet data provider is used to
connect to OLEDB providers. You can use ODBC drivers (you have to download
the ODBC dotnet data provider, it came out after Visual Studio). There are
also native managed providers that are providers written especially for
Dotnet rather than OLEDB or ODBC. There are managed providers for Oracle
(from at least three vendors), SQL Server etc.

So, if you are looking at going against Oracle from Dotnet you can use OLEDB
(which is what you are talking about for MSDAORA) or you can use a managed
provider for Oracle.

If you go with OLEDB I would suggest using the one from Oracle. Although
both are high quality we have found the Oracle you to be a better performer.
The downside of Oracle's is that it is 100% dependent on the version of the
client. If you are doing a web app then that doesn't matter, you have total
control over the version of the oracle client. It gets to be a real mess at
the workstation.

The other possibility is to use a managed provider. You can download one
from MS or you can use the one from Oracle. The one from Oracle is dependent
on the 9i client (release 2 I believe).

HTH,

Bruce L-C

"Ali" <elham...@hotmail.com> wrote in message
news:uJPL4xvzCHA.1672@TK2MSFTNGP09...

[Ali]

Thanks Bruce, but what makes you think I am a "little confused"???

Ali

"Bruce L-C" <bruce_l...@hotmail.com> wrote in message
news:eZlOWf4zCHA.1776@TK2MSFTNGP09...

[Bruce L-C]

Ahh, it was the claim that MS has an OLEDB provider. This provider has been
out for years. The claim statement made me think you were talking about
something recent. The something recent is their Oracle managed provider
available for download. A lot of people new to dotnet don't understand the
different ways that dotnet can be used. My apology for putting you in that
category.

That being said, we have a lot of experience with their Oledb provider and
have moved away from it because for our application it was wayyyy too slow.
Their oledb provider is extremely chatty with how it works with the database
and over a slow link (our app has to connect over dialup and synchronize
with a local MSDE database) and the performance speed up with using the
Oracle OLEDB provider was huge. Plus, the Oracle OLEDB provider does have
some capabilities that the MS one does not (check metalink for details).

From a functionality viewpoint and stability viewpoint the MS OLEDB provider
performed as advertized and I have no complaints.

If you know the database is not going to change, then I would investigate
both MS and Oracle managed providers instead of going with OLEDB. The
performance benefits are worth it. Plus, at least the Oracle one, has
features not available via OLEDB.

HTH,

Bruce L-C

"Ali" <elham...@hotmail.com> wrote in message

news:uOBLmk4zCHA.2488@TK2MSFTNGP12...

[William (Bill) Vaughn]

And while you're investigating, check out the DataDirect provider as well.

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Bruce L-C" <bruce_l...@hotmail.com> wrote in message

news:OHhsoJ6zCHA.1712@TK2MSFTNGP11...

[Jignesh]

Hi William,
Can you put some focus on what is DataDirect Provider?

-Regards,

"William (Bill) Vaughn" <billvaRe...@nwlink.com> wrote in message
news:#1wcIs#zCHA.2868@TK2MSFTNGP12...

[Bob Beauchemin]

Bill was referring to the fact that a company called DataDirect technologies
sells a .NET data provider for Oracle.

DataDirect Technologies is a company that writes commercial .NET data
providers. They used to be part of Merant and before that, Intersolv.
They've been selling ODBC, OLE DB, and JDBC providers and drivers for many
different databases for many years. They mostly write to the database
protocol layer (TDS, TNS, etc) as opposed to using OCI or other client
libraries.

Bob Beauchemin
http://staff.develop.com/bobb

"Jignesh" <jignesh> wrote in message news:O0xzm8N0CHA.1736@TK2MSFTNGP10...

[Jim Brandley]

I have been trying to get System.Data.OracleClient.OracleDataAdapter to
work. OleDbDataAdapter now works fine with Oracle 8.1.7.4.1, but the direct
provider (from MS) establishes connections, but will not return data.
Instead, I get the message: Distributed Transactions require Oracle9i client
software. I thought this worked with 8.1.7.4.1 as well. Am I missing
something on the server? I know it's not permissions on the web server any
more - I temporarily made IUSR_<machineName> and administrator on the box,
with no apparent change.

"William (Bill) Vaughn" <billvaRe...@nwlink.com> wrote in message
news:#1wcIs#zCHA.2868@TK2MSFTNGP12...

[Yana Wang [MS]]

System.Data.OracleClient is the new Oracle managed provider shipped with
net framework 1.1. It requires Oracle 9i client to be installed.

Thanks,
Yana Wang
Microsoft Developer Support

[Jim Brandley]

Yana - Thanks for the reply. I did get it working with 8.1.7.4.1. It just
cannot participate in any distributed transactions until my customers are
willing to upgrade to 9i.

"Yana Wang [MS]" <yanaw...@microsoft.com> wrote in message
news:TXsusfEE...@cpmsftngxa06.phx.gbl...

[Yana Wang [MS]]

The new provider no longer rely on the registry files and mtxoci.dll to
access Oracle. It requires both Oracle 9i client and Oracle Services for
MTS to be installed in order to make the Distributed Transactions to work
also.

[Leigh Kendall]

Yana,

What version of the Oracle Server (database) is required?

TIA,

--
Leigh Kendall, MCSD, MCDBA

"Yana Wang [MS]" <yanaw...@microsoft.com> wrote in message

news:HKMgLOy...@cpmsftngxa06.phx.gbl...