Professional Web Applications Themes

asp and oracle 9i database - ASP Database

I'm trying to access an Oracle 9i database table and am having a difficult time finding how resolve the error. My error is as follows: --- Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object: 'OracleInProcServer.XOraSession' /access_retrieve_data.asp, line 14 --- My code is: --- <% Language=VBScript %> <% option explicit %> <% Dim OraSession, OraDatabase, OraDynaset Set OraSession = CreateObject ("OracleInProcServer.XOraSession") Set OraDatabase = OraSession.OpenDatabase ("", "username/password", Cint(0)) 'execute SQL Set OraDynaset = OraDatabase.DbCreateDynaset( "Select * from Admin", cint(0)) Do While (OraDynaset.EOF = FALSE) Response.write (OraDynaset.Fields("ID")) Response.write (OraDynaset.Fields("FName")) Response.write (OraDynaset.Fields("LName")) Response.write (OraDynaset.Fields("Phone")) Response.write (OraDynaset.Fields("Email")) OraDynaset.MoveNext Loop 'remove OraSession Set ...

  1. #1

    Default asp and oracle 9i database

    I'm trying to access an Oracle 9i database table and am
    having a difficult time finding how resolve the error. My
    error is as follows:
    ---
    Microsoft VBScript runtime error '800a01ad'
    ActiveX component can't create
    object: 'OracleInProcServer.XOraSession'
    /access_retrieve_data.asp, line 14
    ---


    My code is:
    ---
    <% Language=VBScript %>
    <% option explicit %>
    <%
    Dim OraSession, OraDatabase, OraDynaset

    Set OraSession = CreateObject
    ("OracleInProcServer.XOraSession")
    Set OraDatabase = OraSession.OpenDatabase
    ("", "username/password", Cint(0))

    'execute SQL
    Set OraDynaset = OraDatabase.DbCreateDynaset( "Select *
    from Admin", cint(0))

    Do While (OraDynaset.EOF = FALSE)
    Response.write (OraDynaset.Fields("ID"))
    Response.write (OraDynaset.Fields("FName"))
    Response.write (OraDynaset.Fields("LName"))
    Response.write (OraDynaset.Fields("Phone"))
    Response.write (OraDynaset.Fields("Email"))
    OraDynaset.MoveNext
    Loop
    'remove OraSession
    Set OraSession = Nothing
    %>
    ---

    Any ideas?

    Thanks,

    Wills
    wills Guest

  2. #2

    Default Re: asp and oracle 9i database

    umm.... do you have the up-to-date COM objects installed on the server?



    ________________________________________
    Atrax. MVP, IIS
    [url]http://rtfm.atrax.co.uk/[/url]

    newsflash : Atrax.Richedit 1.0 now released.
    [url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]

    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Atrax Guest

Similar Threads

  1. connection Oracle database
    By Joe in forum ASP Database
    Replies: 2
    Last Post: March 3rd, 07:08 PM
  2. Dump Database / Porting Database to Oracle
    By Sven Anders in forum Informix
    Replies: 6
    Last Post: October 17th, 06:21 AM
  3. memory and oracle 9i database
    By Jerry Weinstein in forum Oracle Server
    Replies: 3
    Last Post: July 4th, 06:24 PM
  4. Oracle asking for pwd on strating up of database.
    By Scott Mattes in forum Oracle Server
    Replies: 0
    Last Post: December 26th, 11:26 PM
  5. Oracle Database Platform
    By Maggie in forum Oracle Server
    Replies: 2
    Last Post: December 16th, 12:40 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139