Record.Open doesn't work

CarlHu · August 13th, 2004, 02:38 AM

Hi, I am new to this forum. would like to ask why I can't make the following code work on my computer (I'm using IIS5 on Windows 2000 server):

Code:

<%
Option Explicit

'Use ADO's Record object to open an URL
Dim objRec
Set objRec = Server.CreateObject("ADODB.Record")
objRec.Open "", "http://localhost/myFolder/"
objRec.Close

The following error always occurs:

Code:

Microsoft OLE DB Provider for Internet Publishing (0x80004005)
Unspecified error 
....asp, line ...

anyone could tell me the reason? would appreciate any kinds of help.

None for now.

happygv · August 13th, 2004, 02:58 PM

Check this out.

ADODB.record

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

chrischapman · January 1st, 2005, 04:29 PM

I am having the same problem with the example on page 615 of Beginning Active Server Pages 3.0

<%Option Explicit %>
<HTML>
<HEAD>
<TITLE>Retrieving Semi-structured Data</TITLE>
</HEAD>
<BODY>
<%
  Dim objNodeRecord, objNodeField
  Set objNodeRecord = Server.CreateObject("ADODB.Record")
  objNodeRecord.Open "","URL=http://lesley/BegASP/"

  Response.Write "<H2>Properties of the folder:</H2>"
  Response.Write "<TABLE BORDER='1'>"
  For Each objNodeField in objNodeRecord.Fields
    Response.Write "<TR>" & _
            "<TD>" & objNodeField.Name & "</TD>" & _
            "<TD>" & objNodeField.Value & "</TD>" & _
          "</TR>"
  Next
  Response.Write "</TABLE>"
  objNodeRecord.Close
  Set objNodeRecord = Nothing
%>
</BODY>
</HTML>

I get the following error message:

Error Type:
Microsoft OLE DB Provider for Internet Publishing (0x80004005)
Unspecified error

I think the problem is to do with permissions but I cannot work out how to solve it.

Help please

bassman · October 18th, 2005, 04:16 PM

I'm having a similar problem with the code on p. 615 also but the error message I get is:

Connection to the server for this URL cannot be established.

I don't think this is a permission error because I can use other asp files in this directory.

My connection code looks like this (this is the line giving the error):

objNodeRecord.Open "","URL=http://192.168.1.108/BegASPFiles/"

Hope somebody has had similar experience.

Peter

cJeffreywang · October 19th, 2005, 09:37 PM

I just had the same error message. http://Computer name/my directory or http://localhost/my directory received the same error message. I even tried using the phyical path, i.e. c:\Inetpub\wwwroot\my directory. The same error message.

-- Jeffrey

C. Jeffrey Wang