Can U use ADO in Active X objects?

[T]

Environment:

IIS on Same machine as the VB IDE which is also the machine the application is being compiled/tested on

Oracle client is installed out on network (local registry entries only)


What I want to do:

Browser requests ASP page
Asp page creates Active X business Object (via vb script)
ASP page executes function of Business object
Business object (using ADO) retrieves record from Oracle
Business Object returns record to ASP page
ASP page returns record to Browser

What actually happens:

This all works fine as long as the VB IDE is up and running. Once I close the IDE, the asp page still creates the active x business object, however it fails when it tries to access Oracle via ADO with the following Message:

"Microsoft OLE DB Provider for Oracle error '80004005'
The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 (or greater) client software installation. You will be unable to use this provider until these components have been installed.
/DBserver/clsDBserver.asp, line 4"

I am new to IIS however this seems like either a security or a path error. Since the Oracle client is on our network, do I need to somehow point IIS to it, or set different security? Does the Registry look different to an application running under IIS then it does running outside of it?


This is hard to figure out since it runs fine with the IDE up.

Any Suggestions would be appreciated.

[Serge]

How do you connect to oracle database??? Can you post the connection string? I'm sure it'll be easy enough to figure it out.