I am trying to call an Oracle ADO connection using ASP but hit into
this COM Surrogate error.
"COM Surrogate has encountered a problem and needs to
close. We are sorry for the inconvenience"
I tried to trace my program its seems like it occurs at the connection
open statement.
Here are my sample codes:
set conn =server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Provider=MSDAORA;Data Source = DATABASE;
UserID='loginid'; Password='passwd'"
conn.Open <------- program abort here!!
Anybody knows what is the problem?
I am using Win XP Pro SP2, IIS 5.1.
Thanks in advance.
Julian