Solved

Object required Error when connect to Oracle

Posted on 2004-10-28
398 Views
Last Modified: 2012-05-05
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
%>
0
Question by:ToBe
    4 Comments
     
    LVL 7

    Expert Comment

    by: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
    %>
    0
     
    LVL 20

    Accepted Solution

    by:
    Oracle client and /or OracleInProcServer dll not installed/registered on web server

    BTW : Should have been 50 points
    0
     
    LVL 7

    Expert Comment

    by:rohanbairat3
    Try that I saw a typo
    Set OraSession = Server.CreateObject("OracleInProcServer.XOraSession")
     Set OraDatabase = objOraSession.OpenDatabase("myoracle","015484/admin",0)

    OraSession
    objOraSession

    0
     

    Author Comment

    by:ToBe
    sorry I just post a dated file
    After I change it the Error still there
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
    I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
    This video discusses moving either the default database or any database to a new volume.

    913 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now