Asp Forum - Where is MSFT OLE DB Provider for Oracle - microsoft.public.dotnet.framework.odbcnet

RosalieRalf

8/4/2005 7:52:00 PM

I am writing an .NET app with an oracle backend DB. I have been told the
most efficient way of accomplishing this is by using MSFT OLE DB Provider for
Oracle. I don't have it installed, or at least I can't find it anywhere. I
have tried loading the MDAC stuff and it says my OS already has it. I am
using XP and .NET 2003. Where do I find the DB Provider??
thx for any help

9 Answers

RosalieRalf

8/5/2005 2:13:00 PM

I have checked and I have MDAC 2.8 SP1 on Windows XP SP2

"RosalieRalf" wrote:

> I am writing an .NET app with an oracle backend DB. I have been told the
> most efficient way of accomplishing this is by using MSFT OLE DB Provider for
> Oracle. I don''t have it installed, or at least I can''t find it anywhere. I
> have tried loading the MDAC stuff and it says my OS already has it. I am
> using XP and .NET 2003. Where do I find the DB Provider??
> thx for any help

Paul Clement

8/8/2005 4:20:00 PM

On Thu, 4 Aug 2005 12:52:02 -0700, "RosalieRalf" <RosalieRalf@discussions.microsoft.com> wrote:

¤ I am writing an .NET app with an oracle backend DB. I have been told the
¤ most efficient way of accomplishing this is by using MSFT OLE DB Provider for
¤ Oracle. I don''t have it installed, or at least I can''t find it anywhere. I
¤ have tried loading the MDAC stuff and it says my OS already has it. I am
¤ using XP and .NET 2003. Where do I find the DB Provider??
¤ thx for any help

Where are you looking for it and how do you know it isn''t installed?

Instead why not use the native .NET provider for Oracle (System.Data.OracleClient)?

Paul
~~~~
Microsoft MVP (Visual Basic)

RosalieRalf

8/8/2005 5:16:00 PM

"Paul Clement" wrote:

> On Thu, 4 Aug 2005 12:52:02 -0700, "RosalieRalf" <RosalieRalf@discussions.microsoft.com> wrote:
>
> Â¤ I am writing an .NET app with an oracle backend DB. I have been told the
> Â¤ most efficient way of accomplishing this is by using MSFT OLE DB Provider for
> Â¤ Oracle. I don''t have it installed, or at least I can''t find it anywhere. I
> Â¤ have tried loading the MDAC stuff and it says my OS already has it. I am
> Â¤ using XP and .NET 2003. Where do I find the DB Provider??
> Â¤ thx for any help
>
> Where are you looking for it and how do you know it isn''t installed?
>
> Instead why not use the native .NET provider for Oracle (System.Data.OracleClient)?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
>

Thx for the reply. I am new to .NET, so excuse the ignorance of what I
think is correct and what is actually correct. I am under the impression
that is comes in MDAC, at least that is what MSDN says. When I use the tool
bar to add the data adaptor, it runs me thru the ODBC and that is where I
expect to see the OLE DB Provider for Oracle. I assume that I am wrong here.
Where do I find this and how do I use it. But, you comment about using the
..NET for oracle makes sense. I have just read that in the past few minutes.
But, how do I find the OLE DB Provider anyway. Been searching and still
curious.

Paul Clement

8/9/2005 3:38:00 PM

On Mon, 8 Aug 2005 10:16:02 -0700, "RosalieRalf" <RosalieRalf@discussions.microsoft.com> wrote:

¤
¤
¤ "Paul Clement" wrote:
¤
¤ > On Thu, 4 Aug 2005 12:52:02 -0700, "RosalieRalf" <RosalieRalf@discussions.microsoft.com> wrote:
¤ >
¤ > ¤ I am writing an .NET app with an oracle backend DB. I have been told the
¤ > ¤ most efficient way of accomplishing this is by using MSFT OLE DB Provider for
¤ > ¤ Oracle. I don''t have it installed, or at least I can''t find it anywhere. I
¤ > ¤ have tried loading the MDAC stuff and it says my OS already has it. I am
¤ > ¤ using XP and .NET 2003. Where do I find the DB Provider??
¤ > ¤ thx for any help
¤ >
¤ > Where are you looking for it and how do you know it isn''t installed?
¤ >
¤ > Instead why not use the native .NET provider for Oracle (System.Data.OracleClient)?
¤ >
¤ >
¤ > Paul
¤ > ~~~~
¤ > Microsoft MVP (Visual Basic)
¤ >
¤
¤ Thx for the reply. I am new to .NET, so excuse the ignorance of what I
¤ think is correct and what is actually correct. I am under the impression
¤ that is comes in MDAC, at least that is what MSDN says. When I use the tool
¤ bar to add the data adaptor, it runs me thru the ODBC and that is where I
¤ expect to see the OLE DB Provider for Oracle. I assume that I am wrong here.
¤ Where do I find this and how do I use it. But, you comment about using the
¤ .NET for oracle makes sense. I have just read that in the past few minutes.
¤ But, how do I find the OLE DB Provider anyway. Been searching and still
¤ curious.

I''m not sure which tool you''re using but yes you should see the Microsoft OLEDB Provider for Oracle
in the list of OLEDB providers.

Can you confirm which tool you are using? Is it the Data Link Properties dialog when creating a new
connection?

Paul
~~~~
Microsoft MVP (Visual Basic)

RosalieRalf

8/11/2005 6:11:00 PM

I am on the toolbar, using odbcDataAdaptor. It puts me into a wizard and
into ODBC drivers. I was expecting to see the driver there, but it isn''t.
How should I be creating the connection??

"Paul Clement" wrote:

> On Mon, 8 Aug 2005 10:16:02 -0700, "RosalieRalf" <RosalieRalf@discussions.microsoft.com> wrote:
>
> Â¤
> Â¤
> Â¤ "Paul Clement" wrote:
> Â¤
> Â¤ > On Thu, 4 Aug 2005 12:52:02 -0700, "RosalieRalf" <RosalieRalf@discussions.microsoft.com> wrote:
> Â¤ >
> Â¤ > Â¤ I am writing an .NET app with an oracle backend DB. I have been told the
> Â¤ > Â¤ most efficient way of accomplishing this is by using MSFT OLE DB Provider for
> Â¤ > Â¤ Oracle. I don''t have it installed, or at least I can''t find it anywhere. I
> Â¤ > Â¤ have tried loading the MDAC stuff and it says my OS already has it. I am
> Â¤ > Â¤ using XP and .NET 2003. Where do I find the DB Provider??
> Â¤ > Â¤ thx for any help
> Â¤ >
> Â¤ > Where are you looking for it and how do you know it isn''t installed?
> Â¤ >
> Â¤ > Instead why not use the native .NET provider for Oracle (System.Data.OracleClient)?
> Â¤ >
> Â¤ >
> Â¤ > Paul
> Â¤ > ~~~~
> Â¤ > Microsoft MVP (Visual Basic)
> Â¤ >
> Â¤
> Â¤ Thx for the reply. I am new to .NET, so excuse the ignorance of what I
> Â¤ think is correct and what is actually correct. I am under the impression
> Â¤ that is comes in MDAC, at least that is what MSDN says. When I use the tool
> Â¤ bar to add the data adaptor, it runs me thru the ODBC and that is where I
> Â¤ expect to see the OLE DB Provider for Oracle. I assume that I am wrong here.
> Â¤ Where do I find this and how do I use it. But, you comment about using the
> Â¤ .NET for oracle makes sense. I have just read that in the past few minutes.
> Â¤ But, how do I find the OLE DB Provider anyway. Been searching and still
> Â¤ curious.
>
> I''m not sure which tool you''re using but yes you should see the Microsoft OLEDB Provider for Oracle
> in the list of OLEDB providers.
>
> Can you confirm which tool you are using? Is it the Data Link Properties dialog when creating a new
> connection?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
>

Paul Clement

8/12/2005 3:49:00 PM

On Thu, 11 Aug 2005 11:11:05 -0700, "RosalieRalf" <RosalieRalf@discussions.microsoft.com> wrote:

¤ I am on the toolbar, using odbcDataAdaptor. It puts me into a wizard and
¤ into ODBC drivers. I was expecting to see the driver there, but it isn''t.
¤ How should I be creating the connection??
¤

I thought you were working with OLEDB and not ODBC. See the following:

BUG: Connection for Oracle Database with ODBC Driver is Not Displayed in Data Adapter Configuration
Wizard
http://support.microsoft.com/?k...

Paul
~~~~
Microsoft MVP (Visual Basic)

CusCom

9/5/2005 2:12:00 AM

I have a similar problem. When trying to configure a data adapter to simply
connect to an Access database, I chose to use the "Data Adapter Configuration
Wizard". However, when I click on the Provider tab, there is nothing listed
for Jet 4.0. I am new to this also, and would greatly appreciate any help.
All books I read presume that the provider for Jet 4.0 is listed here.

"Paul Clement" wrote:

> On Thu, 11 Aug 2005 11:11:05 -0700, "RosalieRalf" <RosalieRalf@discussions.microsoft.com> wrote:
>
> Â¤ I am on the toolbar, using odbcDataAdaptor. It puts me into a wizard and
> Â¤ into ODBC drivers. I was expecting to see the driver there, but it isn''t.
> Â¤ How should I be creating the connection??
> Â¤
>
> I thought you were working with OLEDB and not ODBC. See the following:
>
> BUG: Connection for Oracle Database with ODBC Driver is Not Displayed in Data Adapter Configuration
> Wizard
> http://support.microsoft.com/?k...
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
>

Paul Clement

9/6/2005 1:43:00 PM

On Sun, 4 Sep 2005 19:12:01 -0700, CusCom <CusCom@discussions.microsoft.com> wrote:

¤ I have a similar problem. When trying to configure a data adapter to simply
¤ connect to an Access database, I chose to use the "Data Adapter Configuration
¤ Wizard". However, when I click on the Provider tab, there is nothing listed
¤ for Jet 4.0. I am new to this also, and would greatly appreciate any help.
¤ All books I read presume that the provider for Jet 4.0 is listed here.
¤

Yes, it should be there provided the Jet Database Components are installed. Which OS are you using?

Paul
~~~~
Microsoft MVP (Visual Basic)

CusCom

9/7/2005 2:07:00 AM

Thanks for your response. I am running XP Home, SP2 with all updates
applied. In further searching on the Microsoft website, however, I located
information suggesting registration of about six Jet related files, such as
"msjint40.dll". I used RegSvr32 to complete the registration, and then the
Jet 4.0 Provider was listed in the Configuration Wizard. So, for the time
being, all appears to be well. But it seems strange to me that it was not
listed there before performing the registrations!

"Paul Clement" wrote:

> On Sun, 4 Sep 2005 19:12:01 -0700, CusCom <CusCom@discussions.microsoft.com> wrote:
>
> Â¤ I have a similar problem. When trying to configure a data adapter to simply
> Â¤ connect to an Access database, I chose to use the "Data Adapter Configuration
> Â¤ Wizard". However, when I click on the Provider tab, there is nothing listed
> Â¤ for Jet 4.0. I am new to this also, and would greatly appreciate any help.
> Â¤ All books I read presume that the provider for Jet 4.0 is listed here.
> Â¤
>
> Yes, it should be there provided the Jet Database Components are installed. Which OS are you using?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
>

microsoft.public.dotnet.framework.odbcnet

Where is MSFT OLE DB Provider for Oracle

RosalieRalf

RosalieRalf

Paul Clement

RosalieRalf

Paul Clement

RosalieRalf

Paul Clement

CusCom

Paul Clement

CusCom

x Login to ForumsZone