Link to home
Start Free TrialLog in
Avatar of ToBe
ToBe

asked on

Object required Error when connect to Oracle

hi all

When I use the following code to Connect Oracle, it came a Object required  error. Would you help me out?

The database name is myoracle
username : 015484
password : admin

<%
Dim OraSession
Dim OraDatabase

 On Error Resume Next
 Set OraSession = Server.CreateObject("OracleInProcServer.XOraSession")
 Set OraDatabase = objOraSession.OpenDatabase("myoracle","015484/admin",0)
 If Err.Number>0 then
  Response.Write "<font color=red>Connection Error :" & err.description & "</font>"
  response.end
 End if
%>
Avatar of rohanbairat3
rohanbairat3
<%
Dim OraSession
Dim OraDatabase

 On Error Resume Next
 Set OraSession = Server.CreateObject("OracleInProcServer.XOraSession")
 Set OraDatabase = OraSession.OpenDatabase("myoracle","015484/admin",0)
 If Err.Number>0 then
  Response.Write "<font color=red>Connection Error :" & err.description & "</font>"
  response.end
 End if
%>
ASKER CERTIFIED SOLUTION
Avatar of jitganguly
jitganguly
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rohanbairat3
rohanbairat3
Try that I saw a typo
Set OraSession = Server.CreateObject("OracleInProcServer.XOraSession")
 Set OraDatabase = objOraSession.OpenDatabase("myoracle","015484/admin",0)

OraSession
objOraSession

Avatar of ToBe
ToBe

ASKER

sorry I just post a dated file
After I change it the Error still there