Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional 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
 
Old November 22nd, 2005, 11:50 AM
Authorized User
 
Join Date: Mar 2005
Location: arima, West Indies, Trinidad and Tobago.
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to arimakidd
Default Local Host Problem

My OS is windows 2000 (not server). Database is Access and I have an asp page that allows you to retrieve information from the database. Everything works fine the first time, immediately after when you try the second time the page just comes up blank. No info from the database shows. If you wait a while it works again but once again another attempt gives a blank page. Is there some kind of setting in IIS I have to specify that would overcome this problem. I am using asp and i have specified only one recordset to open up. In fact I am using a Table Procedure. Not to sure if this is a problem but the OS is Windows 2000 running 256 or thereabout RAM. Service pack 4. If more information is needed I'll be glad to give it. Just in case, here's the Procedure:

Code:
Sub MakeTable(SourceIn,dsnIn)
Dim oRSmt
Dim countn
Set oRSmt = Server.CreateObject("ADODB.Recordset")
oRSmt.CursorLocation = 3 'Used to keep count of how many records are going to be displayed
oRSmt.Open SourceIn, "DSN=" & dsnIn
oRSmt.MoveFirst
Response.Write "<TABLE BORDER='1'><TR>"
For Each Field in oRSmt.Fields
 Response.Write"<TH>" & Field.name & "</TH>"
Next

Do While NOT oRSmt.EOF
 Response.Write "<TR>"
 For each objField in oRSmt.Fields
 Response.Write "<TD>" & objField.value & "&nbsp;</TD>"
  Next
countn = oRSmt.RecordCount 'Assign the record count to variable countn
oRSmt.MoveNext
Response.Write "</TR>"
Loop
Response.Write "</TR></TABLE>"
Response.Write "<p>Total Number of Entries are " & countn & "</p>"
Response.Write "<a href='javascript:void(0)' onClick='self.close();return false'>Close Window</a>"
Response.End
End Sub

<% 
Dim sORce
sORce = Request.Form("report")
'Response.Write sORce
call MakeTable(sORce,"KeyData;pwd=private")
%>
Hope I can get some help

 
Old November 23rd, 2005, 05:23 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Can't see anything obvious arimakidd, but it's worth closing & destroying the recordset once you have finished using it.

HTH,

Chris





Similar Threads
Thread Thread Starter Forum Replies Last Post
aspx site works local, but not on FTP host(?) zuz29 ASP.NET 1.0 and 1.1 Basics 1 June 2nd, 2006 08:27 AM
Can't Up load to local host one image Jacky Kenna Dreamweaver (all versions) 4 July 26th, 2005 12:09 PM
mysql local host address darith Beginning PHP 1 April 27th, 2005 07:51 PM
local host denied pseudo class Beginning PHP 6 October 19th, 2004 05:17 PM





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