I can't access my Oracle database from ASP pages. For example, I tried to

write the following page:



<% Option Explicit %>





Dim objConnection 

Dim objRecordset 

Set objConnection = Server.CreateObject("ADODB.Connection") 

With objConnection 

.ConnectionString = "Provider=MSDAORA;Data Source=Oracle8_dev;" & _ 

"User ID=scott; Password=tiger;" 

.Open 

Response.Write "ADO Provider=" & .Provider & " " 

Set objRecordset = .Execute("SELECT sysdate, user FROM dual") 

End With 

Response.Write "System Date=" & objRecordset.Fields("sysdate") & " " & _ 

"User=" & objRecordset("user") 

Set objConnection = Nothing 

Set objRecordset = Nothing %> 

but I can see nothing when I brows this page. The browser reply with "The

page cannot be displayed" and hte following error:



Error Type:

Microsoft OLE DB Provider for Oracle (0x80004005)

Oracle error occurred, but error message could not be retrieved from

Oracle.

/Assaf/Test.asp, line 26





Any suggestions??



 

YOURS

Mohammad Assaf