Dave is right. What you are doing here is using the Microsoft Driver
for Oracle. This is not oracle objects for OLE, in which case your
Provider becomes "OraOLEDB.Oracle".
You might wanna try the ODBC approach as well, of course after you
configure the Oracle Net names. First of all, make sure you are able to
connect to Oracle, using any tool like SQLPlus., then go further.
Install the Oracle ODBC driver for your oracle version on your PC
running IIS, and configure a DSN using the ODBC Administrator. You can
also test the connection from the ODBC Administrator tool after you
create your connection and make sure that everything is right...
Brijesh Mathew
Received on Thu Sep 22 2005 - 01:44:15 CDT
