Error: Microsoft OLE DB Provider for Oracle (0x80004005)

[ajacode]

Using SmallBusinessServer2000 (Windows2000 Server)with all latest SP's why do I get this error message when I try to run and ASP page against an Oracle Database located on the same SBS server?
Here is the error message. I can view the data and manipulate tables views etc using the same Visual Interdev Project connection object but when it tries to run in the browser window I get the following error.
*************
Error Type:
Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle 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 later client software installation. Provider is unable to function until these components are installed.
***************

I know all the Dll's are there on the server, because I see them listed in the ODBC freivers tab window.
(infact I created the DSN used on the server just in case.
Any Ideas ??

Thanks

AJ

 

[Turkbear]

2 things:

1: OLEDB is not the same as ODBC so the dlls being there may not matter. so,

2: Be sure your Oracle Home and path to its bin directory is correct before trying to connect.

Try using a DSN-less connection ( much prefered in general)
Like this:

Set objDC = Server.CreateObject("ADODB.Connection")
objDC.ConnectionTimeout = 15
objDC.CommandTimeout = 30

'Code to connect to Oracle  objDC.Open "Provider=MSDAORA.1;Password=yourpass;User ID=youruser;Data Source=your_tnsnamers.ora_entry;Persist Security Info=TRUE"

hth,