I wrote some asp pages using an oracle database with this connection string:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open("Provider = OraOLEDB.Oracle; Data Source =Esemar; User id=scott; password=tiger")
that was perfect for oracle 8i using a DSN called "Oracle ODBC driver" available in Microsoft ODBC Administrator.
But now I need to use Oracle 9i instead, and the only dns available is "Oracle in Orahome92": the connection test is always successfull, but when I try to connect my asp page with the same string as above it says an error of "unable to find the provider"