Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | 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 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
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 22nd, 2005, 10: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

Reply With Quote
  #2 (permalink)  
Old November 23rd, 2005, 04: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

Reply With Quote
Reply


Thread Tools
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
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



All times are GMT -4. The time now is 05:55 PM.


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