set conn=createobject("adodb.connection")

set rs=createobject("adodb.recordset")

' Oracle client is required to be installed on your box

conn.open= "Provider=OraOLEDB.Oracle.1;Password=***;

PersistSecurity Info=True;

User ID=****;

SERVER=****;

DataSource=****;

DBQ=****;

"sql="your sql query to retrive the records"

rs.open sql,connrs.close

set rs=nothing

conn.close

set conn=nothing