Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    22

    Unanswered: Can't access .asp pages in explorer

    Hi

    I can't seem to access a asp page in explorer, I have set up my connection to oracle using the Oracle Provider for OLE DB, in a UDL file. I entered my username and password, tested connection and it said connection made.

    Pasted the line from UDL file in notepad which said my Provider, password, and user id into Dremweaver into the correct area. This worked fine and I could see my database with it tables, then created a recordset, tested this and this displayed my data from the table.

    But when I inserted a dynamic table, and used that recordset, I have had nothing but errors, when previewed in explorer.

    First one was "ADODB.Recordset (0x800A0E7A)
    Provider cannot be found"

    I then went and changed the include from file to virtual, and the following error is displayed:

    "The include file 'Connections/oracle.asp' was not found."

    oracle.asp is the file with the info abt provider, password userID.

    Any held would be great

    Cheers

    Rob

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What does your directory structure look like ?

  3. #3
    Join Date
    Dec 2003
    Posts
    22
    Originally posted by rnealejr
    What does your directory structure look like ?
    My local directory is c:\web\

    (And within this directory is the folder where the oracle.asp page is stored under connections) c:\web\connections

    My testing server is c:\Inetpub\wwwroot\web\
    This also has the folder connections, with the oracle.asp page within that folder

    Cheers

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Where is the page that is including the oracle.asp page ?

  5. #5
    Join Date
    Dec 2003
    Posts
    22
    Originally posted by rnealejr
    Where is the page that is including the oracle.asp page ?
    That page is in the c:\web directory and try's to link oracle.asp page in c:\web\connections

Posting Permissions

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