For some reason my global.asa file is not firing. I have it located in the
root of my website (e.g., wwwrootmywebsiteglobal.asa) and I have the web
site configured as an "application" in IIS. When I modified the file I also
stopped and restarted the web server.
Problem with global.asa not firing 100% of the time. This error crops
up several times throughout the day but if you wait a while and reload
the page (could be 5 mins or an hour) it will suddenly start working
again.
The error is:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/footer.asp, line 101
Line 101 in the footer.asp file reads:
InnovationRS.Open sql, Application("AnymousConnection")
I believe that bad code would produce a persistent error message. The
application would either work, or generate an error 100% of the time,
not be intermittent. The error is now appearing 3 or 4 times a day with
different users reporting it, but like I said, if you wait a while and
refresh the page, it is working again. Code:
I can fire an app at the server using wshell.run but how can i pass information to the application?
View Replies View Related
A drop down list is populated with certain values from the database and when the selection is changed the post is posted back to itself and ceratin other processing takes place on the same page, based on the selected value.
I have modified the code to make a default list item selection (using option selected etc. ) when the page loads the 1st time. I also want the onChange event to fire the 1st time (by taking this default selected item) on page load, not just when user makes a selection from the list.
I'm workinbg in Visual Studio 2003. I'm experimenting with creating a
session variable, and from all I can gather. the Session_Start event is not
firing.
In Global.asx.vb, in the Session Start event, I have the following:
Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs)
' Fires when the session is started
Session("varTest") = "123"
End Sub
First off, when I set a break point at that line, it is never reached when
the application starts. Secondly, when I try to post a test alert(), to
display Session("varTest"), it comes up blank (no error). Finally, if I set
Session("varTest") = "123" in my asp page, then display it, it shows up, all
of which leads me to believe that the global.asax file is not seen by the
project, even though it was inserted automatically.
My Session_OnStart works but Session_OnEnd does not work. Here's the
code...can anyone tell me what's wrong with my code or if anything else
on the server that needs to be changed. The Session_OnStart does create
the folder for me with the SessionID as the folder name but
Session_OnEnd does not delete that folder. Code:
In the code behind of my ASP.net web page I have code written that is
dynamically creating a button. Here is a sample of how I define it.
//Define Variable
Button btnNext;
public void someMethod()
{
btnNext = new Button();
button += new EventHandler(this.btnNext_Click);
//then i add the control to the page, then call its click event
btnNext_Click();
}
When I clickthis button on the page, the page postsback and its onclick
event is never called (stepping through the code shows that it never gets
reached). If I click the button a second time, the method is called and it
works fine.
I have designed a form which process database Insert, edit and Delete(datagrid). I input userid,password and privilege in textboxes which has validation controls to verify data keyed in. And press the button to perform insert operation. Upto here is fine.
I want to perform edit or delete operations. I put datagrid for that one. After clicking the Update button for the row, the validation controls are firing again. I need to input some temporary data in the form fields to perform actual update operation. How can i stop firing validation controls at this stage?
I have one application folder containing all ASP code files. I want host multiple sites pointing to same code. Can I do this ? If YES then how I can assign diffrent global.asa to each application...
View Replies View RelatedI have added a db driven marquee to my site and need to combine the global asa's to 1 global asa file. Code: ......
View Replies View RelatedI am trying to put a condition in my Global.asa file based on the server
name.the reason, I want to set a global string as a application variable based on
the server I am on.
I also need to set a coonection string based on the value of the server.
I need to use this connection string to retrieve values from an sp in
application on start that sets a load of global variables so I can't really
do this anywhere else.
I have a site which until this morning, was on a remote server. The structure was that the "site" was actually a folder on the server, as I am designer and use this arrangement to develop sites. Under the root directory, I had modified the global asa file to include session variables. Ok, so I download the site (folder) to my hard drive, and put it in the folder of "MY Documents" called MyWebs. I then opened VB Studio and created a new solution, which is pointing to the before mentioned directory in My Documents. When I pull the site up in IE, the session variables were not being called, and I realized I had not copied over the asa file. So I did so, placing a copy of it in the hard drive's c inetpub wwwroot directory, and also directly in the my docs mywebs directory,and the site's directory as well. It seems it is still not being called.Can anyone tell me what I am doing wrong?
View Replies View RelatedIs the Global.asa file resolved before parsing the 'Include' (files) or
after parsing the 'Include' (files)?
I have IIS 5.0 installed on for a test server. the global.asa file runs perfectly.
when tryng the same application on win server 2003 IIS 6.0 the global.asa does not fire. i have set the application as a virtual site and given rights for iwam and iusr. What else could be the problem. Code:
How does IIS 6.0 treat the global.asa file? I had the following problem;
1. uploaded a new site to the win3k server
2. had incorrect db connection string in Session_OnStart in global.asa and website caused errors.
3. Changed the global.asa file to include the correct details. Saved the file. Still got the same errors.
I could not resolve this unless restarting the WWW Service on this server. In IIS 5.0 the global.asa file would reload after resaving it (as the timestamp is updated).
I even waited the next day before restarting the service because I though Session_OnStart expires after my session ends...but the error was still there
in the morning.
Hopefully someone will make sense of it for me. Here is the code (I inherited) in the global.asa
Sub Application_OnStart
Application("DB.ConnectionString")= ""
Application("MaxLoginAttempts") = 5
Set Application("Con") = Server.CreateObject("ADODB.Connection")
Session("Test") = Now()
End Sub
Sub Session_OnStart....
Is it possible to use ADO in global.asa?I simply want to creat a log of each visit to the site?
View Replies View RelatedI created a dll to track our users and I want to call it in the Global.asa. How do I do this? I've seen the <OBJECT> tag to create an object, but I'm not sure how to use it correctly.
View Replies View RelatedI dont have any idea about Global.asa. Is it for global variable declarations?
View Replies View Relatedi'm a little bit confused with using application_onstart.. as u can see in the following code... my DB connection and SQL statements is currently included in my application_onstart event.. but, unfortunately, i wasn't able to reference Application("sUser") in my asp when i tried to run my website Code:
View Replies View RelatedWe have over 100 asp pages that reference a table (distribution_components). We added a new column and primary key to that table, so now we have to modify the where clause to include that column (we have to make the new column = to a session variable in the page)
The table appears 531 times in our code. Is there some util or method that allows us to change it globally, other than going to each occurrance, and adding the new column to the where clause.
Basically session_onend will not fire in my global.asa files! I have just made a very simple test to prove its not my programming and it still doesnt fire.
Session_onstart works a treat but onend will not work even if you force the session to expire with abandon. I have tried on 2 of our servers now and it doesnt work on either.
my simple test is this:
Sub Session_OnEnd
application("test") = "hello"
End Sub
Now surely that should work. i obviously have a page that writes that test variable to the page but its always empty.
Set IE 6.0 ver. X to "Block all Cookies" in privacy settings and try
this code in three separate files.
<-- Global.asa -->
sub Session_OnStart
response.cookies("test") = "-1"
end sub
<-- Global.asa -->
<-- testcookie1.asp -->
<%Response.Redirect("testcookie2.asp")%>
<-- testcookie1.asp -->
<-- testcookie2.asp -->
<%=request.cookies("test")%>
<-- testcookie2.asp -->
I get "-1" on testcookie2.asp
Anyone else get the same result?
Why am I getting the cookie in this test?
So when *does* Session_OnEnd fire in my Global.asa file? Does it fire when
they click a link to leave the site? Does it fire when the session times out?
I need to Ban IP's on my IIS server. I know the IP's I need to ban, but how to I write the global.asa file correctly.
View Replies View RelatedI have an ASP application that is a electronic purchase orders system. My
problem is that only 3 people can authorise a purchase order. When a
purchase order is selected I update the table to show that the field is
locked. If they complete the form then the database is updated and the lock
is removed, all though at this stage the record moves into another part of
the system and the lock becomes redundant.
If however they dont complete the form the record is left in a permanent
locked state, it could be that they decided to look at the record then
navigated away or closed the browser.
So i thought maybe i could stick some code that updates the database into
the session_OnEnd in the global.asa, so after 20 minutes when the session has
ended the lock will free. I don't however have any experience with this and
don't even know if this will work. The code won't be a problem its just
whether this process will actually work.
I am thinking that I code put the order_id into a session variable then when
the session variable ends i run a sub in the .asa file that gets the session
variable and updates the table.
I am in much need of some help with my global.asa file. I use ASP and mySQL. In a nutshell, When a registered user logs in, a field in I have a field that gets updated in my DB Table. It is a TINYINT. When they log in, it updates the value to 1, when they log out, it updates it to 0. I use a tiny iFrame to create a loop displaying users with the value of 1. Basically a cheasy "Who's Online" function.
How ever I am now trying to create a global.asa file to say when the session times out, I want the global file to just update the value back to 0. I am also attempting it so that if the users browser window closes and then gets reopened PRIOR to the timeout limit, It knows they are still logged in. I can provide my script if anyone thinks they can help. !!!!!!!!!!!!!!!!!!!
I think my final thought would be that when the user closes their browser, that the session ends and the DB field gets updated from a 1 to a 0.
i'm trying to update my db when the user sessions expires..... So i put the codes below on the golbal.asa file... i tried it a few times but this code wont work... but when i tried in Sub session_on_start it is okay... i notice that we could not use server.mappath or any other objects/variable other than Session or Application variable on global.asa .... have any of u guyz trtied the same thing and works
<script language="vbscript" runat="server">
Sub Session_OnEnd
set adoConn = Server.CreateObject("ADODB.Connection")
adoConn.Open "Driver=MySQL ODBC 3.51 Driver; Database=dhl_21Feb; Uid=user;Pwd=user;"
set rssession = adoConn.execute("Update session set LogoutTime = '10.20',status = 'Log_'")
I would like to start using the global.asa file on an ASP app to store
information like connection strings, contact e-mail addresses, etc. However,
the person I report to is nervous about this, mostly because he's never been
exposed to it.
He is of the opinion (because he "thinks he heard somewhere") that
application variables - and the ASA file in general - is bad. He's giving me
a bit of push-back until I can satisfy him that introducing this won't cause
problems for the site.
Anything I could find on the MSDN just says how to use it, how it works,
etc...which is stuff I already know. Has anyone had any problems with the ASA
file? Does it cause any performance lagging? Is there any chance that the
Application_OnStart event won't fire?
If i want to declare a global variable in a one page and can be retrieved anyway in any page. how can i do that? the normal one that we declare is :
dim execno
dim month
but what about the global variable???
I have a site wich is in a subdirectory of the webSite. I have to use a global.asa file to set session.timeOut even i create an IIS application on the subDirectory global.asa don't run ?!?
if i create a virtual directory instead of IIS application, the global.asa run fine.
How can i do to run global.asa on a subDirectory ?
With global.asa application variables can be set. Later can a script in your
application change the value of those variables. But when IIS is restarted
the old values are used again. Is there a way to get the changes that are
done into global.asa?
my global.asa file doesn't seem to be executing in IIS and i don't know how to make them run. Any ideas how to execute the global.asa file in IIS 5.1 ,
View Replies View RelatedI have to write Global.asa with session_onEnd. Firstly, If my IIS have a number of application, may I have a number of global.asa on each application folder? or, i can just have a global.asa on the wwwroot?
Besides, I found that it seems doesn't run when I put global.asa on the application folder.