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

    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
    Mumbai, India
    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 -->


    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

    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