Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #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
Default

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.

Regards
Colin


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





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