I am trying to access an Oracle 9 database using ADO. The problem I am
having is currently the provider is MSDAORA. To my knowledge this will
not
work in accessing a 9i database. Does anyone know how I can access Oracle
9i
using classic ASP and vbscript? This is an example of the code in the web
page. If anyone can help it would be greatly appreciated.
sUserID = Request("ID")
sPassword = Request("Password")
Session("ErrMsg") = ""
'establish database connection
sDatabase = Application("database")
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Provider = "MSDAORA"
oConn.CursorLocation = adUseClient
'see if we can successfully connect
oConn.Open sDatabase, sUserID, sPassword
