Connect to Oracle from asp page:
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=OraOLEDB.Oracle.1;User ID=xxxx;Password=xxxx;Data Source=xxxxxx;"
or
oConn.Open "Driver={Microsoft ODBC for Oracle};Server=xxxxxx;Uid=xxxx;Pwd=xxxx;"
(both worked for me when i used Oracle in OraHome 92 driver to create ODBC)
|