Results 1 to 2 of 2

Thread: asp & oracle

  1. #1
    Join Date
    May 2002
    Location
    atlanta
    Posts
    2

    Unanswered: asp & oracle

    i know this is a dumb question, so lets just get it out of the way

    i am trying to connect to oracle using asp, i can connect to oracle using the personal oracle sql++ client, and my friend's code works for her, but i just can't get it to connect for me, i know i don't have a registered dll of some sort but i'm unsure as to which dll and how to go about registering it

    source code:

    <%
    Set OraSession = CreateObject("OracleInProcServer.XOraSession")
    Set OraDatabase = OraSession.DbOpenDatabase("tcpclient", "scott/tiger", cint(0))
    %>
    <%
    Set OraDynaset = OraDatabase.DbCreateDynaset("select * from mobo", cint(0))
    Do While(OraDynaset.EOF = FALSE)
    Response.write(OraDynaset.Fields("moboID"))
    OraDynaset.MoveNext
    Loop
    'remove OraSession
    Set OraSession = Nothing
    %>

    error message:

    Microsoft VBScript runtime (0x800A01AD)
    ActiveX component can't create object: 'OracleInProcServer.XOraSession'
    /SeniorProject/testconnect.asp, line 3

  2. #2
    Join Date
    May 2002
    Location
    atlanta
    Posts
    2

    fixed it

    reinstalled oracle client, fixed the problem...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •