asked on

Problem Connecting Web Page to Oracle

Hi folks. Last night I successfully connected an ASP page to an Oracle8i database using ADO...

Dim cn
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Provider=MSDAORA.1; Data Source=oracle.optionbase.com", "system", "manager"

I don't know what happened, but tonight I get the following ridiculous error...

Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle error occurred, but error message could not be retrieved from Oracle.
/oracle.asp, line 24

The Oracle Service is started. I don't know what else to do. Please help.

robbert

I'd never connected to Oracle, but you can also try this connection string:

oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
"Server=oracle.optionbase.com;" & _
"Uid=system;" & _
"Pwd=manager;"

ASKER CERTIFIED SOLUTION

chupaul

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

piratepatrol

ASKER

Yeah, I tried that also. It would work sometimes, but other times it would give me that silly unknown error. I found a way of connecting that's less prone to errors...

cn.Open "Provider=OraOLEDB.Oracle; Data Source=oracle.optionbase.com; User ID=system; Password=manager;"

This works most of the time, but sometimes I get an exception occured error. It would go away after I restart the computer.

This is some weird junk! I don't think Oracle is meant for Windows 2000. Too many bugs. SQL Server is the way to go! Thanks for all your help. God bless you all.

piratepatrol

ASKER

Comment accepted as answer