Re: Oracle 9i and ASP: responsible DLL found

gd6502_at_eudoramail.com wrote:
> After long trouble I think I've partially understood the cause of
> strange behavior between ASP/IIS and Oracle9i. Here's what it happens.
> - Start the server on which resides IIS and Oracle
> - From a client's browser I open ASP application that calls Oracle,
> and get this error when opening connection:
> Type of error: ADODB.Connection (0x800A0E7A) Impossible to find the
> provider. It is possible that it is not installed correctly.
> - I make the same test from the browser of the server and it works
> - I immediately redo (without modifing anything) the test from the
> client and finally it works; after this, the application runs correctly
> without problems
>
> Verifying the active processes I have found that opening ASP
> application from the server's browser, the
> C:\oracle\ora92\bin\oranbeq9.dll is loaded, depending from the TNS
> Listener process (TNSLSNR.EXE). Once loaded, this DLL remains available
> and all runs regularly.
> Then, reloading the TNS Listener service, the DLL is not loaded
> automatically; it's automatically loaded when a browser application
> (even if from client this time) calls the Oracle data. Therefore the
> error is only displayed with "cold" server.
>
> Does anyone has idea about the reasons of this behavior?

Sounds like it may be a bug that is perhaps fixed with some maintenance from oracle?

What oracle maintenance if any has been applied to the 9i server after the software install?

Have you opened up a ticket with oracle on this?

> Peppe
Received on Tue May 02 2006 - 12:36:38 CDT