www.webdeveloper.com
Results 1 to 3 of 3

Thread: asp oracle connection error

  1. #1
    Join Date
    Oct 2006
    Posts
    23

    Unhappy asp oracle connection error

    <meta http-equiv="Content-Language" content="en-us">
    <%
    'Declare variables as OLE Objects.
    Dim OraSession
    Dim OraDatabase
    Dim OraDynaset


    'Create the OraSession Object.
    Set OraSession = CreateObject("OracleInProcServer.XOraSession")

    'Create the OraDatabase Object by opening a connection to Oracle.
    'Be sure your own username and password to access your Oracle db
    Set OraDatabase = OraSession.OpenDatabase("", "scott/tiger", _
    Cint(0))

    'Create the OraDynaset Object to execute SQL statement
    Set OraDynaset = OraDatabase.DbCreateDynaset(_
    "select * from mytable1", cint(0))
    %>
    <html>
    <body background="myback.jpg">
    <p><b><font size="6" face="Bookman Old Style" color="#FF0000">At last u got it
    !!!</font></b></p>
    <p><b><font face="Bookman Old Style">(If u r unable to see the updated result
    then press <font color="#FF0000">F5</font> or <font color="#FF0000">Refresh</font>
    button.)</font></b></p>
    <table border=1 ID="Table1"&gt;
    <%
    Do While(OraDynaset.EOF = FALSE)
    Response.Write("<tr><td>")
    Response.write(OraDynaset.Fields("ID"))
    Response.Write("</td><td>")
    Response.write(OraDynaset.Fields("UserName"))
    Response.Write("</td><td>")
    Response.write(OraDynaset.Fields("Phone"))
    Response.Write("</td><td>")
    Response.write(OraDynaset.Fields("Email"))
    Response.Write("</td></tr>")
    OraDynaset.MoveNext
    Loop

    'remove OraSession
    Set OraSession = Nothing
    %>
    </table>
    </font></body></html>




    i cant run the page to view tables and the error i get is:

    Microsoft VBScript runtime (0x800A01AD)
    ActiveX component can't create object: 'OracleInProcServer.XOraSession'
    /asporacle/view.asp, line 10


    the database i am using is oracle 8i

    can someone please help me out

  2. #2
    Join Date
    Mar 2006
    Posts
    591
    Make sure your component (dll) 'OracleInProcServer.XOraSession' is registered correctly.
    At this moment your webserver can't find and create an instance of it.

  3. #3
    Join Date
    Oct 2006
    Posts
    23
    thanks for your reply ...

    can u tell me the name of this DLL and from where i can locate or download it ??

    i am using Windows XP with service pack 2 !!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles