Rather than opening and closing a new connection to the database on every page, I have placed that connection into an Application variable. This has worked fine so far.
My issue is that I have a logoff page where it closes that connection.But this means that users who are on the application will not be able to access that connection.The obvious answer is that I don't close the database connection.But my problem is, I would like to eventually close that database connection.
How can I determine if an application variable (not session variable) exists?How can I determine that there are not any users on the application?
Which is the most efficient way to hit the database: 1) to open/close the connection for each call to the database on a page (we have Subs that do this); 2) or use the same connection and close it at the end? My feeling is that 2 is better, but just wanted to confirm with the experts.
I have developed an ASp files i have used lot of objects in it like recordset and connection objects, but some of the objects is not being closed.so is it possbile to write a code which automatically closes all the objects opened without mentioning the name given to the object.
I'm looking at another developers code and I'm now confused about the correct way to close a database connection and destroy the object. I would normally do it this way: Code:
We have our web site setup on two seperate servers. They are connected together through a BIG/IP server. I'm not sure how many of you are familiar with BIG/IP (load balancing) but I'll give you a quick explanation:
When a user goes to our site, they hit our BIG/IP server first. This server looks at our two web servers and determines which one has more resources to spare. The BIG/IP then redirects the user to that server, where they are on the rest of the time they are on our site.
So we have two web servers with duplicate web sites running. My problem is I need to run one application object between both servers. Is this possible, or is there a work-around?
I am developing ASP application with complicated login system. There is several group of menu options. Each have form 5 to 15 sub-options.
User can work with any combination of options and sub-options and can see only these menu options which are allowed for him. "Rights rules" are store in SQL Tables and are getting after logon.
Now a questions:
1. what is the best way to store this menu structure (Session object is not allowed because it uses Cookies) ?
2. What is the best way to handle the "rights rules" ?
Below you can find quick links to information about the Application Object. I would write a post like my CDONTS one, but I just don't have time, but when I do, I'll see if I can get one done.
An intro to the Application object, this its in JScript but its easy to change Using the Application Object to Improve Performance
HOW TO: Declare an Array at Application Level Scope in Active Server Pages (Q165293)
A Real-World Example of Caching Data in the Application Object W3 Schools Application Reference
HOW TO: Use the Application Object to Store ASP State
I am trying to get to the application object from a seperate class in my ASP application and I dont want to pass the object in as the class is inherited to lots of other classes. So i can have something like the following:
Imports System.Web.UI.WebControls.DataGrid
Namespace Classes.Inheritable Public MustInherit Class EntityCollection
Implements IDisposable
Private mobjDataConnection As Classes.Databases.DBConnection
Public Sub New(ByVal strSQL As String) mobjDataConnection = Application("DataConnection") End sub
There seems to be plenty of discussion about caching in the Application Object, however, I cant find any info on what realistic limitations there are and how they are measured.
What are the factors that will limit performance / storage of many individual or single large bits of data with application scope? eg database driven list boxes (that dont require up to the minute data) 10 * 100 options? 100 * 100 options? kb's? megs of info? How much can I cache?
My asp application allows a number of users to log into it. Each user has a different type of access level (General User, Manager or Administrator). I want the administrator to be able to see how many other users are logged into the application at a particular time. How can I do this? Would the use of an application object work for this?
We have pretty simple ASP (not ASP.Net) application, which has been running fine on IIS4 and IIS5. It has now been moved to a sever running in the DMZ and managed by a 3rd party. The server is Win2003 and IIS 6.0.
Within the Globe.asa file, have an Application_OnStart SubRoutine (Visual Basic) and it bombs out on the first line:
I'm looking for a way to allow only one user to access my web form at a time. so that if there is a user using my web page / html form.. then the next user is directed to another page. So only one user is allowed access at any given time .I was hoping there is a way to do this with Application variables.
I am currently working on a small asp application. Now I would like to store the complete database connection in the application object. Note I want to store the connection NOT the connectionstring. For that purpose I wrote a small asp include which connects to the dbase and stores the connection object to the application object. However when I use this include in my pages then it doesnt work. What I am doing wrong? Here is the code:
I'm using application variables for a web based sales tracking application. I use the variables for stuff like connection string, database name, etc. I store the values in a asp file that is included in a login page. The assignments are in a procedure that I then call on the login page. This is done everytime a user connects to the login page.
what's happening to the variables? Are they being overwritten everytime a user accesses the page? I'm not checking for the existence of the variables. I just call the routine everytime the page is accessed. I know the values are shared for all users but, I was wondering if I should check for the existence of variables? Will it free up resources? Should I be using locks?
i am making a site using asp. in this i am using mssql server2k as backend. i ve created a dsn. i want use global.asa file for creating connection object so that i don't ve to create con object in every .asp page. for that i ve write following code
<script language="vbscript" runat="server"> sub Application_onStart()
set con=server.createobject("adodb.connection") con.open "dsn=pc;uid=sa;pwd=;database=dbname"
end sub sub Application_onEnd() set con=nothing
end sub sub Session_onStart()
end sub sub Session_onEnd()
end sub </script>
now anyone tell me how to use that connection object in any asp file for fetching the recordset.
Sub Session_OnEnd Dim Conn Set Conn = Server.CreateObject("ADODB.Connection") Conn.ConnectionString = Application("Connection_String") Conn.Open 'here is the error .... End Sub
A Conn object is created the same way in Session_OnStart and is used throughout the application, and Application("Connection_String") still exists here (I tested). So I suppose the error is caused by the fact that we are in Session_OnEnd.
The connection object is stored in a application object in a database.asp file which is included on all the pages. This is something that I didn't code but I am incharge of fixing it because we are having alot of problems with the IIS.
How do I remove the connection object from the application object? I am a bit confused, what if i just use a variable to set the connection and then still include the file on all the pages. Would that work? Code:
I'm working on a quick wrapper so that I can connect to a database, run a quick query, get the needed info and pass it on to the next page that needs it. I've been programming for a long time but not with ASP/VBscript and think it's just something stupid that I've overlooked. Code:
i have quotation_start.asp which was set to be a small window (height=250, width=500). there is a YES button and some data on this page. when user clicks YES, data will be saved into database, quotation_start.asp will be closed automatically and a new page, quotation_admin.asp will appear in the main window at rightFrame. everything is ok except the quotation_start.asp never close. it remains there. here is the code:
i want to know a way to end the session as the user closes the window. As the user closes the reg_conf.asp page, i want the session of this user to end as well. how to do? how to detect the closing of the browser? ive used global.asa.
I am trying to set a cut off limit date on my page. For example if the class limit is 40, it should automatically close the registrations. How would I code for that ?
This code was written by someone elase. But I have to add this functionality of setting limits. The code is: Code:
Host Environment: IIS in window 2003 server, three web servers, one load balance, ASP (not ASP.net) code set.There is part A codes in one asp page (page A) to open a new window (Window B). The new window like a clock non-stop running. There is part B codes in the page A need to close window B.
There is no problem if the there is only one web server. It works. When there is a load balance and more than one web server, then the window B can not be closed.
Is it possible to move to all the open RS and connections? I open different recordsets on my page and in the end I need to close them and close connection. Problem is I need a function to do that to have it on every page.
Is it possible to travel through all open recordsets like it is possible to travel through all the querystrings and form data?
i have a exit button...where when i click on it..it should show msg box..asking whether to close the form or not?..if yes it should colse the form and show the main form...if no..it should redirect to the same form..hw to do this using asp.
