Oracle 10G Server + ASP.Net + IIS = crash?

I formated my webserver and i installed in it Oracle 10G server, and
.Net framework with IIS. My application was working perfectly in the
old server, now the application is throwing ORA-12514 exception, but
when I start the SQL Plus it works perfectly. It occurs only in the
.Net application.

My server is a Win2003 SP1.

What is goin on? Any one solve this problem or have ever hear about it?

Thanks
Francisco

Peter
Fri Sep 02 07:15:54 CDT 2005


"Francisco Spaeth" <francisco.spaeth@gmail.com> wrote in message
news:1125598145.950974.209900@g49g2000cwa.googlegroups.com...
>I formated my webserver and i installed in it Oracle 10G server, and
> .Net framework with IIS. My application was working perfectly in the
> old server, now the application is throwing ORA-12514 exception, but
> when I start the SQL Plus it works perfectly. It occurs only in the
> .Net application.
>
> My server is a Win2003 SP1.
>
> What is goin on? Any one solve this problem or have ever hear about it?
>
> Thanks
> Francisco
>
You don't mention the previous version of Oracle, the version of Visual
Studio or the technology you are using to interface with the Oracle
database. If I may assume you are using the MS OracleDataAdapter class in
VS2003/.NET Framework 1.1, that predates the release of Oracle 10g and may
not be fully compatible.
You may want to check on otn.oracle.com and/or investigate this technology:

http://www.oracle.com/technology/tech/windows/odpnet/index.html

--
Peter [MVP Visual Developer]
Jack of all trades, master of none.

Francisco
Mon Sep 05 07:21:55 CDT 2005

Sory,

The .Net framework is version 1.1.4322.573
The MDAC version is 2.82

Francisco
Mon Sep 05 07:22:56 CDT 2005

And using MS OracleDataAdapter...

Peter
Mon Sep 05 08:21:36 CDT 2005


"Francisco Spaeth" <francisco.spaeth@gmail.com> wrote in message
news:1125922976.531456.211150@o13g2000cwo.googlegroups.com...
> And using MS OracleDataAdapter...
>

OK, then my previous advice applies.

You may want to check on otn.oracle.com for articles on compatibility issues
and/or investigate this technology:

http://www.oracle.com/technology/tech/windows/odpnet/index.html


--
Peter [MVP Visual Developer]
Jack of all trades, master of none.

Francisco
Mon Sep 05 13:22:53 CDT 2005

Ok, I see that with the oracle 10 client it works fine but when I
install the server it works for a little while...

Grateful
Francisco