I'm trying to connect to an Oracle box from a machine running IIS on W2k using the code below:

set oConnO = server.CreateObject("ADODB.Connection") oConnO.Open ("PROVIDER=OraOLEDB.Oracle.1;Data Source=*datasource*;User ID=*uid*;Password=*pw*;")

The server is valid, as are the username/password, but when I try to connect, it takes forever then finally fails with "The remote procedure call failed and did not execute."

If I try the same thing with a SQL server it works with no errors. Can anyone help me? I simply want to connect to an Oracle db on machine1 using ASP & IIS from machine2.