Re: Managed provider for Oracle

well, you are right about that.  The managed provider won't compile with
beta2 because it implements the IDbDataParameter interface which isn't
introduced until later builds of the framework.  I did not realize that the
managed provider was an ODBC data source.  Is there any place I can find
detailed information on the inner workings of it?  I documentation provided
with the managed provider is pretty weak.  I couldn't find much on MSDN or
Googling for it.  I had assumed that it used an OLE DB provider internally.
I was told that you should not use any non managed provider with Oracle and
.net, which says to me that MSDAORA and OraOleDb.Oracle are out.  I couldn't
get any detailed information on this either or the related bugs, just don't
use it.  Do you know anything about this?

TIA,
Francis X. Knebels
Merck Vaccine Division
WP97-3W507
215.652.7710


-----Original Message-----
From: Beauchemin, Bob [mailto:[email protected]]
Sent: Wednesday, June 19, 2002 7:22 PM
To: [email protected]
Subject: Re: [DOTNET] Managed provider for Oracle


No. Visual Studio Server Explorer is hardcoded to use OLE DB (hence, any OLE
DB data source). It is also special-cased to, when you select the SQL Server
OLE DB provider, use the SqlClient data provider instead (in most wizards).
You can also use Server Explorer to explore (only explore) an ODBC data
source, but you can't use any of the wizards with an Odbc data source and
the Odbc data provider.

The Oracle data provider should not even work with beta2. You'll need to
install the production release of .NET to use it.

Hope this helps,
Bob Beauchemin
[email protected]


-----Original Message-----
From: Knebels, Francis [mailto:[email protected]]
Sent: Wednesday, June 19, 2002 8:39 AM
To: [email protected]
Subject: [DOTNET] Managed provider for Oracle


can the Oracle managed provider be used in the Server explorer?  I
downloaded and installed it, but I don't see it in the data conenctions list
of providers.  am i doing something wrong or do I have to write my own code.
btw i'm still using Beta2

Francis X. Knebels
Merck Vaccine Division



----------------------------------------------------------------------------
--
Notice:  This e-mail message, together with any attachments, contains
information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that
may be confidential, proprietary copyrighted and/or legally privileged, and
is intended solely for the use of the individual or entity named in this
message.  If you are not the intended recipient, and have received this
message in error, please immediately return this by e-mail and then delete
it.

============================================================================
==

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.

------------------------------------------------------------------------------
Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that may be confidential, proprietary copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please immediately return this by e-mail and then delete it.

==============================================================================

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.