I created a DLL in VB6 that handles all the database access for some ASP pages that I created. The application basically authenticates the user against the database, does a search, reads a graphic file from the database, writes it to a folder on the server, then displays it in a browser. All was working great on my laptop with XP Pro. I now installed it on a 2003 server with IIS. I am now getting intermittant problems.
Somtimes I get an internal error 500, but most times the page just hangs and never comes back. If I change the permissions on the folder where the graphics file gets written to give 'Everyone' full access, everything works great. Once I reboot the server, it stops working again. If I then remove the 'Everyone' permission from the folder, it works again. Upon reboot, it doesn't work again. It appears that anytime I change the permissions, it starts to work, but it doesn't matter what I change. Either adding the 'Everyone' group or removing it makes it start to work.
Sometimes my asp page will hang and do nothing until I refresh. It happens 5 percent of the time. I just don't know why. I can't duplicate this as well.
The problem is that after a while (approx 2 hours) of the application first starting pages stop displaying and seem to hang. There are no error messages on the screen, event log or IIS log - If i do a view source on the page it just shows me a "<html></html>"
the problem can be fixed by restarting the WWW Publishing Service.
Does anyone know how to up the logging in this or have any idea about what the problem is?
I have a piece of form processing software that basically saves the form content to an Access database and then sends the data in the form of an email to the specified email address.
I had it running perfectly. Everything worked as it should.
But then strange things started to happen, it would start to slow down in the admin backend when adding new form processors (contains info like required fields, recipents email etc). Code:
I have a Windows 2003 Server Web running 5 web sites. Every few days, the ASP pages stop responding. There are no events in the event log. The HTML pages are still served successfully. These pages have no database interaction (others use MySQL). I have to restart IIS in order for the pages to work again. I haven't been able to find anything about this issue on the web. Has anyone seen this before? Any idea how to fix it?
At work we have to real-time generate a report(excel format) which involves a number of table joining. So to export into excel contentType 'application/vnd.ms-excel' is used, and data are written as table, looping each row of recordset data as table row.
Problem is when user hit export and attempt to open/save the file, file would then be downloaded at constant rate. But during this time, entire server would be irresponsive and in a hang-like state, this is expereinced by all users.
When they attmept to visit another asp page they would wait until the page eventually timeout. This will continues until the report was completely generated and downloaded by users.
I have asp pages running from a hosting server. In there I open a bunch of connection to an access database. When we ported over to win2k3, the site started going down, or hanged (with no response).
I am suspecting a set of possibilities: 1-we could have reached access max db connections, 2- we could have some leaking left-open connection that we are not closing 3- there might be some security restrictions on win2k3 that are blocking the site or it might be other reasons.
how to debug or troubleshoot this given that we don't own the hosting server (and we don't want to debug on it as well;). Are there some tools, or iis/asp options that we can use to trace down from where is comming the issue?
Running a Win2k box. Every few hours, IIS decides to stop serving asp pages. The machine has multiple hosts on it and this occurs with ALL asp pages. Running IISrecycle resolves the issue.
I'm using SAFile up to upload a file to the webserver. I wanted to have a progress bar so the user doesn't get to impatient. I know how to do it and everything works, however while the upload is occuring the web server pauses. I can't execute any ASP pages on that site from my browser they all "pause" until the upload is done.
Last week I posted in the graphics forums regarding a photo I have that I needed to slowly change from day to night.Now I have the various stages, I need them to display on my site, according to the time of day.For example:
Between 5am and 7am display the early morning picture Between 7am and 5pm display the day picture Between 5pm and 7pm displayy the evening picture
I'm having a domain change foisted upon me and the test I did resulted in every last ASP and ASP.Net script stopping cold. Nothing but plain old html worked. Is there a FAQ or some other document available that outlines what has to be done when the IIS server machine is disconnected from one domain controller and reconnected to a totally different one? If not, does anyone here know what would have to be changed to make the ASP code play nice in the new domain?A relevant bit of info, they're also changing the name of the administrator account. I don't know if that would contribute to the death of ASP* on the system, but it might.
i have an insert record and edit record page. When inserting to the db, it uses now(). When I go to edit an existing record the date stays as the original date. How do I make the date change to the amended edit date?
When I have the recordset in the order as follows, all works well: (Recordset2.Fields.Item("ProductName").Value) (Recordset2.Fields.Item("ShortDescription").Value) (Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does'nt show.
how best to convert an application which is all in English to be able to roll the app out to say Germany or France and it all appears in the correct language
My site uses frames.I have a header frame, a menu frame and a main frame. When the page opens, the header frame and the main frame are generic. The main frame has a log-in dialog. Once the user logs in, they are taken to a 'main' page and I want to replace the header and menu frames with other frames .
I need to set up an HTML table or the like, with 4 columns. Each column needs to have a header with a FRIDAY (dd/mm/yy) date. i.e. this weeks Fridays date is 16th Feb, the following is 23rd Feb etc. So, I need column 1 to be headed 16th Feb, col 2 to show 23rd Feb etc. As this week passes, the dates need to move up 1 week, so that next week, col 1 will display 23rd Feb and so on. These headers need to change according to the date. Please can you advise how I best achieve this ?
I was talking to someone back at Uni. He showed me his web site. He had - and + to increase the size of his web page or to decrease it so the user can always see everything on screen. He did it in asp. I'm interested to know how it was done.Does anybody know how to do this?
I have two textbox in the form. what i want to do is update the second text box based on the sponsorid entered by the user. I want to display the member name based on the memberid which is retrieved from the database on the bases of entered sponsorid by the user.
i extracted all the data when the page loads from the database but unable to call it on blur event of the text box. The variables cannot be accessed in the vbscript because these are for server side and not accessable on the client side. What is the way around this problem.
i want to know how to change the password or replace it with new password and for more details see the attachment. note that i am using Dream weaver for development and Access database to save users information.
I have domain name, eg www.abc.com. Use the Dynamic DNS web site to register. How the IP of www.abc.com. can be shown once I click The Domain Name,e.g.click http://www.abc.com.
Then show http://123.123.123.123
Is it the ASP program can help me? or any other solution.
I am running a marquee across the top of my page. The text for the marquee is initially loaded from a SQL Server Database. However, as users look at this page the text may be updated by an administrator of the site.
To account for this, I tried to use VBScript to code the onstart event of the marquee. In the script I was trying to check for updated text but I don't believe it is possible as it seems the database code only runs on initial loading of the page. Any ideas on how to requery the database for the updated text?
I run a site using a blog script (dblog) where if you want to open an article from the homepage, it links to a page called article.asp. For example if I want to open article 101 the link goes to article.asp?article=101 but the title (the metatag) is always the same.
What I want to do is having the title change from article to article, retrieving it from the database. So if I open article.asp?article=101 the <title> displays the title of the article 101.
However when the results are listed and a file link is clilcked the browser is looking at the local drive for that users PC i.e c:. Is there something I can do to make it look on the local drive of the server? This is for internal network use, so there would be no security implications.
<% If rstResults.Fields("doctitle") = "" Then %> <strong><a href="<%= PathToVpath(rstResults.Fields("path")) %>"><%= PathToVpath(rstResults.Fields("path")) %></a></strong><br /> <% Else %> <strong><a href="<%= PathToVpath(rstResults.Fields("path")) %>"><%= rstResults.Fields("doctitle") %></a></strong><br /> <% End If %>
i have a login form on my site. if the user enters incorrect detaisl then the script will kick them back to the page they were viewing before submitting the login form (login box is on all pages) using: Code:
I have a total cost listed on my page, followed by 3 radio buttons named postage. What i would like is for the total price that is displayed on the page to change depending on radio button that is clicked e.g. US Rate, UK Rate, Eur Rate. Im not sure how to do this without sending submitting the form to a new page which is not possible given this situation.
I connect to a databae with my ASP code to run special reports and every now and then the DB server seperate from the server I have the ASP on is really being used and I get SQL timeouts after 60 seconds.
to connect I use a DSN. Is there a way to set the timeout to 360seconds instead of 60 when using a DSN?
I am installing phpBB and it says that i need to change the permissions on config.php to be writebale by all (666 or-rw-rw-rw within your FTP Client). does anyone know how to do this. I have tried right clicking and going to permissions but i do not see anywhere to change it to 666 or -rw-rw-rw .
