asp and oracle 9i database

[wills]

I'm trying to access an Oracle 9i database table and am
having a difficult time finding how resolve the error. My
error is as follows:
---
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create
object: 'OracleInProcServer.XOraSession'
/access_retrieve_data.asp, line 14
---


My code is:
---
<%@ Language=VBScript %>
<% option explicit %>
<%
Dim OraSession, OraDatabase, OraDynaset

Set OraSession = CreateObject
("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.OpenDatabase
("", "username/password", Cint(0))

'execute SQL
Set OraDynaset = OraDatabase.DbCreateDynaset( "Select *
from Admin", cint(0))

Do While (OraDynaset.EOF = FALSE)
Response.write (OraDynaset.Fields("ID"))
Response.write (OraDynaset.Fields("FName"))
Response.write (OraDynaset.Fields("LName"))
Response.write (OraDynaset.Fields("Phone"))
Response.write (OraDynaset.Fields("Email"))
OraDynaset.MoveNext
Loop
'remove OraSession
Set OraSession = Nothing
%>
---

Any ideas?

Thanks,

Wills

[Atrax]

umm.... do you have the up-to-date COM objects installed on the server?



________________________________________
Atrax. MVP, IIS
[url]http://rtfm.atrax.co.uk/[/url]

newsflash : Atrax.Richedit 1.0 now released.
[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!