I've been cobbling together a rather complex web utility, and was wondering
if there is a way to monitor the number of data connections and open
recordsets currently being used by the server. I am using IIS5. I'm
essentially looking for a tool that would help identify sloppy code by
showing a list of currently open data connections or recordsets.
in my main page i need to retreive record set from the database as well as search for products. but the recordsets i need to retrieve are located in a different table then the products i need to search. is this possible to do ?
how I might go about displaying all current open db connections in ASP, either for a particular web app/page or hopefully all of IIS ? We are having a few issues with IIS hanging and we feel that it is related to db connections that were opened and not closed. I would like to be able to write an ASP page that could show me the current amount of open db connections from IIS.
I need to do this from the IIS side not the SQL Server side. I can already see the number of sessions in SQL Server but I am more interested in trying to find asp pages which have opened a connection to some db and not cleaned up properly afterwards.
Is there a way to detect open recordset and connection objects easily? I have hundreds of pages of code making up this web application I wrote and I want to make sure I didn't leave any loose ends. Short of going page by page, connection by connection, I'd love to discover any issues a different way. Does anyone know of a strategy?
Many a page has ADO Connection objects that were opened but never closed. The Connection object allocates its own resources when it is opened. When the object goes out of scope without being explicitly closed, the resources ASP allocated for it are freed, but the resources it allocated on its own are not. These eventually clutter up the server and slow it down to a crawl.
My question is, is there a way to track down these orphaned resources and forcibly free them from ASP, without restarting IIS or the server? Or does one have to wait for the unused Connections to time out and release themselves? I know that good coding practice is best, but is there a temporary fix to tidy up these connections left open?
I have a set of scripts that accesses a SQL2000 database on another server. After several days of investigating an extreme slow-down on my web server I did a netstat-a command and found DOZENS of connections to the SQL server still open. Here's just a small sample of this. Code:
I have a fairly advanced order processing / tracking system I designed with MS Access, MySQL & ASP.
I want to add an enhanced order tracking facility where a user can send an email to a specific address we set up, with an ID & PO Number in the subject / body, and then have our system reply with the required information.
Is this done with asp or something completely different ? When an email comes in, what would auto scan all incomming emails and read the data ?
Is there a special component I need for this. I just want this to happen in the background, whilst possibly sending me an alert email each time the system is used. This will help me guage the services required.
The user will choose either yes or no from the radio button in web page for all the questions.
The data (yes or no) will be store in the database for future information. I try to use the different name for both radio buttons(yes and no) but the function for the radio button doesn't work anymore(the user can check both of the radio button). so, i have to put the same name for both radio buttons.
The problem is, how can i track the data that user key in (whether yes or not) if i put the same name for both radio button??
Besides that, can anyone please tell me where can I get the MSE7.exe program?? This program doesn't exists in my computer in folder office10. The office that i used is microsoft office 2000.
I have a main form which opens a popup when you click on a button (via jscript). From there the user can can click another button to open another popup with just the calendar control on it.
I want the user to be able to click on a day on the calender and then pass this date back to a text box on the first popup. Remember the first popup is already open and I've already evaluated whether IsPostback = true on the first popup.
Is it possible to post the form data and open the page as a modal window? Because when I do the following, it will open page2.asp in a new window, but I still able to manipulate page1.asp. I want to make page2.asp as modal window.
I need to either write or buy a program that will let me Track each user.By this i mean I want to know when the logged on, how long they where on,and what PAGES they visited.
I have a search form that display result based on the user search criteria. the result displayed through paging when the user select a specific product description to look at then go back to the search result the user will lose it's place.
my question is: How can I let the user search the database for all the products that I have then select a specific product to read the description of it then be able to go back to the original search. I have the first part working fine but to be able to go back to the original search that I need your help. Code:
I thought when I discovered the power of session.sessionID I was onto a winner... but in the last month or so have been finding more and more of it's shortfalls (all down to whatever specific users have running on their machines)
Passing data through querystrings isn't ideal as people might go and type a url in to move around.
Imagine a CD of say 20 songs. Each song is a table row
[Title] [Artist] [TrackNo]
I need a way for the user to change the way the songs are listed by allowing them to change the track numbers. What is the smartest way to do this? I think it would be kind of trick to have a couple of <IMG> up and down arrows per each song. The user would click on either the up or down arrow to move the song accordingly. But I don't know how to go about that. Whatever variables are passed, the process would have to check to see if there is another track# +/- 1 each time.
Then I thought maybe it would be easier to just list the songs with a form box next to each song where the user manually entered the desired order,then submit the form. But that also has it's share of issues like checking for existing track numbers, users who can't count,etc.
I got a web based application. I need to keep track of number of users coming to use this applcation on a daily basis. This application is read only one. I have to veiw the traffic for a month. What is the best way to capture this information. I appreciate any help or related article link.
currently was doing a asp project, this project allow ppl to upload file to server and allow other user to browse it or download it. is the any way to track the time between after user click on the file to browse it and close it? What i mean is to track the time that a user access certain file in asp.thx a million.
I need t track the Visitor of My Site. I mean I want to know the Number of All Visitor and the number that a Specific Visitor has Visited the Site. actually I've not so much problem with All wisitor but the Specific one.
what do U believe the best solution is? I've tried catch the User IP and handle it with that, but I've been told it's not Possible, if it's not, how can I do this, or if Yes how ?! (is it Request.ServerVariables("REMOTE_ADDR") or not?).
I am working on this intranet website which includes access mdb for storing employee ratings. In this website I am using table which consists of username and paswords of the users who can log in. So whenver there is a login. the ASP code checks this table for matching results nd then it lets the user in.
Im using sessions to keep track of user. For viewing the records through the browser, I am not tracking the user But I want to record any actions by the user if he is updating the employee tables . SO I have created a seperate table for User_Actions...this table will record..timedayusernametable nameaction( insert or update or both)So every time the user updates or appends and the transaction is committed , this table would be populated.
I have created a html email newsletter. After ages of working with it I managed to get it past the spam boxes .
Ok I would like to create some tracking. I know you can apply tracking based on a graphic that has been downloaded from the email. How would I be able to track an image download from the server.
I've built an email application which uses the 'ASPEmail' component to send mail to a list of around 3000 subscribers.
It's not possible with the stats software I have to track individual graphics - which would have been a good way to track the number of people who looked at the email. So is there any other way to do this tracking? Will javascript work well in mail clients, or can I embed a hidden iframe etc?
i've got a client that wants to be able to review records about IIS generated emails.
in his own words, he wants the "ability to track and report message status (i.e. how many messages were sent successfully, how many were blocked, how many bounced back with an incorrect address)"
i'd start by adding a new row containing the email address, dateTime, etc when first sending the email, but how to track the rest of the info? for instance, if an email bounces back, does it bounce back to IIS or to the "from" email address? what about the blocked (i.e. spam filter) emails? is there a way to track blocked email? since most spam filters don't generate response emails, there's not much i can really do about this, is there?
this will be run off an IIS6 server. can anybody tell me my options?
I have googled on this and saw a large number of examples to keep a track on the number of hits on a URL. However I wanted to find out from the guys here if they prefer any particular one out there for any specific reasons.
I found this code for a global.asa file and in the tutorial it says it can be used to display how many people are on a given website. I don't see how this done. Is there a session variable of some sort that I take from this code and output it onto a page?
I want to track the steps the user has gone through to get to this page and then display links so they can click on them to go back to that page. I would do this as hard code but the problem is most of the pages can be accessed from several different pages.
ex. a product page a home page and a specials page
the path to the product can be home -->product or home-->specials --> product
exactly like the viewing link at the top of this page but in asp.net instead of php.
i developing a web site and having a login function. i want my web site to track down the time between a user logged in and log out the website and stored it into database. when next time the user come in again, the time he spent in the web site will add on to the record in the database. may know where i can look for the information about this function or coding to refer?
When a student taking a quiz having a duration of 2 hrs, a timer will start and keep track the time.
So if he logout or close the window, the remaining time should be recorded into the database. And when he take the same quiz again, the timer will not restart but continue from the previous time.
E.g i take a quiz having a duration of 60mins, and when i logout the time duration remain is 30mins. And when i logon and take the quiz again, the timer countdown from there 30mins but not begining of 60mins.