Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: asp to oracle(9.2.0)database connectivity

    " Microsoft OLE DB Provider for Oracle (0x80004005)
    Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed."

  2. #2
    Join Date
    Feb 2004
    Location
    Mumbai, India
    Posts
    1
    You must install an Oracle client or server before you can use this.
    Is your oracle database on the same server as IIS? If so, then set up the listener.
    If on a different server, then install Oracle client, create the listener link (use Easy Config).

    Then for your ASP pages, use the following

    <!-- #include file=adovbs.inc -->

    <%

    Dim myCon
    Dim myRS

    set myCon = server.createobject("ADODB.connection")
    set myRS = server.createObject("ADODB.recordset")
    myCon.ConnectionString = "Provider=MSDAORA;Persist Security Info=False;User ID=<user>; password = <pwd>;Data Source= <listener name >"
    myCon.CursorLocation = 3
    myCon.Open

    set myRs = myCon.execute("select * from tab")
    ' this will return a recordset of tables
    %>

Posting Permissions

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