Application Object And Close Connection
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?
View Replies
ADVERTISEMENT
Can anyone give me a simply and short paragraph answer to the quest : How does ASP close/exit an application?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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" ?
View Replies
View Related
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
View Replies
View Related
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
View Replies
View Related
The following code exists in a Global.asa file:
----------------------------------------------
<%
Set Application("Thing")=Server.CreateObject("THINGDOER.THINGY")
%>
----------------------------------------------
Will the above code snippet:
create a non-object Application variable named "Thing" & place it in
the Contents collection of the Application object?
-----OR------
create an Application object named "Thing" & place it in the
StaticObjects collection of the Application object?
View Replies
View Related
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?
View Replies
View Related
I'm having trouble with the workflow described bellow:
1. Asp page 1 on server A contains an iframe.
2. Asp page 1 submits a form targeted to the iframe, to Asp page 2 on
server B.
3. Asp page 2 runs in the iframe and at some point might decide to submit a
form targeted to the _top frame, to page 3 on Server B.
4. Page 3 loads in the top frame. Code:
View Replies
View Related
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?
View Replies
View Related
Im trying to detect multiple logins...
Im using a application object in my global.asa, for some reason it doesnt seem to work. here is my code
<script language="vbscript" runat="server">
Sub Session_OnStart
Session("LoggedIn")=0
End Sub
sub Application_OnStart()
Application("Logged")=1
End sub
</script>
In my pages if i print the Application("Logged") value, it does not show....
View Replies
View Related
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:
Application("cnSecurity_ConnectionString") = "connectionProperties"
With the error:
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject failed
Globe.asa, line 25
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
Why doesn't the following code work?
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.
View Replies
View Related
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:
View Replies
View Related
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:
View Replies
View Related
Can I use ASP code to close the current window?
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
I made a popup for uploading some files.My popup looks like this:
function openpopup(){
var popurl="upload_tst.asp"
winpops=window.open(popurl,"","width=400,height=400,")
<a href="javascript:self.close()">close </a>
}
</script>
My problem is that I cannot close the popup.
View Replies
View Related
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:
<td bgcolor="#EEEEEE"><div align="left" class="style26"><span class="style4"><%=(rs_ClassInfo.Fields.Item("ClassLimit").Value)%></span></div></td>
View Replies
View Related
Pls what code can i use to automatically close and asp page after execution.
View Replies
View Related
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.
View Replies
View Related
I suspect i don't close well my recordset.how can i CLOSE / FREE / RELEASE
recordSets and connections
in order to avoid server memory loss?
View Replies
View Related
When I user decisedes to leave my site.How can I detect that imidietly and trigger code to run from that?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
