Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP 3.0 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 12th, 2005, 07:59 AM
Registered User
Join Date: Nov 2004
Location: Milton Keynes, , United Kingdom.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to zippo
Default Problems with ADODB.Open

I am trying to implement what I have learnt from the Beginning ASP book, in a modification to an existing ASP application. I am working on an IIS installation in my own laptop, under Windows Server 2003.

The application that I am modifying presents am HTML table containing a list of files that are in the website, having retrieved them from an index; each table row includes a hyperlink to the file itself, and the user can click this to view the file that is required.

What I am trying to do is to allow for the fact that the different files may be in different places in the virtual folder tree, and that the incoming user may or may not be permitted access to them (limited by folder permissions). I want to exclude from the table those files that will not be accessible.

In order to get this working, I have started by introducing the code to test for the file's accessibility - I have not yet done anything yet to actually restrict access.

So as I loop through the table, I attempt an ADODB Open on each file as I retrieve its URL, with On Error Resume Next in effect so that I can test the State property of the record object to see whether the Open worked.

The problem is that this Open *always* fails, yet if I ignore the failure and build the table row anyway (commenting out my new code), the hyperlink access to the file works OK.

Because this was puzzling me greatly, I went to the Record.asp example from the book, and started modifying that to try to reproduce the problem. But here I get a different problem; if I use the ADODB Open to access a data file in the BEGASP folder or a subfolder of it, this works OK, and it still works OK if I execute the Record.asp page from my own application folder; but if I change Record.asp to try to access a file in my own application folder, the browser hangs indefinitely - and this happens whether I execute record,asp from the BEGASP folder, or from my own application folder.

I would much appreciate any advice & guidance that anyone can offer!!
  #2 (permalink)  
Old April 22nd, 2005, 05:16 AM
Registered User
Join Date: Nov 2004
Location: Milton Keynes, , United Kingdom.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to zippo

Hello? I am sorry to see that nobody seems to have been able to advise me on the topic above - I'm still stuck in the same place, and I really would appreciate any advice that anyone has to offer.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Open document, Open second doc and copy to first justabeginner Word VBA 1 March 7th, 2007 02:47 AM
ADODB.Stream Open via URL (Unspecified error) blackadder_ba2 Classic ASP Components 2 December 7th, 2005 01:30 AM
ASP ADODB.Stream Open via URL (Unspecified error) blackadder_ba2 Javascript 0 December 5th, 2005 02:21 AM
How to get adodb.record from adodb.recordset John Pennington Pro VB Databases 1 November 20th, 2004 06:17 AM
Problems with Sqlcommand.Connection.Open() leion General .NET 4 March 18th, 2004 12:41 AM

All times are GMT -4. The time now is 10:13 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.