Accessing an Oracle database from an ASP page?
Posted on 2003-11-25
I have a machine with the Oracle 9i client installed on it. The server (on another machine) is 220.127.116.11. The ASP application I've been assigned to customize accesses a lot of COM+ components which access the database. The ASP code that was given to me *never* accesses the database directly, only the COM+ components do that.
The change I need to make involves accessing the database. I would really rather do that in the ASP code as opposed to developing a COM+ component (which may STILL not even work!!!).
Everything I try to access the database directly gives me some sort of error that the Oracle OLEDB driver is not found.
The developers told me that one of the COM+ components exposes its own ADO connection to the database as a property. I tried that:
Set objMyComPlusDBConnection = CreateObject("MyComPlusApp.objMyComPlusDBConnection")
Set adoConnection = CreateObject("ADODB.Connection")
The error I get is:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/mywebappname/myfilename.asp, line 84
I tried doing it by brute force by opening VB 6.0 and opening a DataProject project and using that to construct connection strings for me - I tried choosing Oracle Provider for OLE DB, Microsoft OLE DB Provider for ODBC Drivers and Microsoft OLE DB Provider for Oracle and got 3 different versions of "provider may not be installed" errors.
The COM+ components are clearly able to access the database, as are any ADO apps I write in VB.
Any ideas why I'm having trouble getting to them through ASP???