Unanswered: asp to oracle(9.2.0)database connectivity
" 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."
You must install an Oracle client or server before you can use this.
Is your oracle database on the same server as IIS? If so, then set up the listener.
If on a different server, then install Oracle client, create the listener link (use Easy Config).
Then for your ASP pages, use the following
<!-- #include file=adovbs.inc -->
set myCon = server.createobject("ADODB.connection")
set myRS = server.createObject("ADODB.recordset")
myCon.ConnectionString = "Provider=MSDAORA;Persist Security Info=False;User ID=<user>; password = <pwd>;Data Source= <listener name >"
myCon.CursorLocation = 3
set myRs = myCon.execute("select * from tab")
' this will return a recordset of tables