Microsoft provider does not work with Oracle DB connection

[George Viveiros]

I have an ASP.Net application that connects to an Oracle 8.1.7 database.
If I use the Microsoft provider MSDAORA the connection fails every time.
If I use the Oracle provider the connection works.

I need to use the Microsoft provider because there is a connection class
we have to use that uses the Microsoft provider. There are other
machines in this group that use the Microsoft provider without any
problem.

I am looking for help on what could be the show stopper.



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Turkbear]

On Tue, 16 Sep 2003 14:12:17 -0700, George Viveiros <viveirosg@npt.nuwc.navy.mil> wrote:

>I have an ASP.Net application that connects to an Oracle 8.1.7 database.
>If I use the Microsoft provider MSDAORA the connection fails every time.
>If I use the Oracle provider the connection works.
>
>I need to use the Microsoft provider because there is a connection class
>we have to use that uses the Microsoft provider. There are other
>machines in this group that use the Microsoft provider without any
>problem.
>
>I am looking for help on what could be the show stopper.
>
>
>
>*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
>Don't just participate in USENET...get rewarded for it!

If I understand correctly:
The same connection info, just a different provider is used.
The Microsoft one ( using the same connection info) can connect to the same database on some machines but not on one.
The Oracle provider works on all of them.

What error does the failure return?

[George Viveiros]

In the locals window under connection object I see ServerVersion:
<error: an exception of type:
{System.InvalidOperationException}occurred>

In Catch ex As Exception of the try catch block, ex.message is:
"Exception has been thrown by the target of an invocation". ex.Source is
: "mscorlib".

In ex.InnerException.Message I see: "Oracle error occurred, but error
message could not be retrieved from Oracle.".

I am running IIS 5.0 and Visual Studio 2003 on a Windows 2000 machine
with all the latest service packs.



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!