Is there a way that i can force a drop of all connections to a database. My problem is Access keeps locking my database, i have multiple users using this database, at different periods of the day, and i need a way to clear all connections, i.e at set points throughout the day or at request.
I do close the connection and set all record sets to nothing not sure what else i am missing?
how can I clear Session("sString") on a hyperlinK?
example:
<a href="default.asp">Goto page 1</a>
the Session("sString") should be "" (blank)
I have a website that would set two cookies when a user logs in
successfully.
<%
response.cookies("login_status")="OK"
response.cookies("login_id")="12345"'This value is from database.
response.cookies("login_id").domain="mysitexyz.com"
%>
and I have a question in "removing/deleting/cleaning the cookie when
the user logs out.
From my understanding there are two methods -
#1 (I am currently using)
response.cookies("login_status")=""
response.cookies("login_id")=""
#2
response.cookies("login_status").expires=now
response.cookies("login_id").expires=now
My questions is, what's the difference, advantage and disadvantage of
these two methods?
I am asking this because I have noticed that there are some problems
in #1. In my computer (I use IE7) if I login as one user, logout, and
then login as another user, the cookie value will get mixed up.
Somehow the response.cookies("login_status") can display correctly but
response.cookies("login_id") cannot. But if I clean my browser cache,
close my IE and reopen it, both cookies work fine.
im using an array inside a do while loop. how do i clear out my array
before i run back through the loop?
how to clear the combobox by calling a function in ASP.
View Replies View RelatedWhen I submit information i post it to a page and when it’s reloaded it runs as code accordingly if I refresh it re runs the asp because the information is still posted. How do I clear the posted information? Or possibly after it runs the asp code alter a value in the posted information.
View Replies View Relatedim using the following code to loop thourgh field to prevent same value being added twice by the user in different fields, Code:
View Replies View RelatedWhen I release session objects I do this
session("username")=""
So whats the difference when I do this
set session("username")=nothing
or
session.remove("username")
Isn't I already release it with a null value?
i have a form with a textarea(the value is taken out from the database) i would like to know if it is possible to erase contents in that file and not delete it using asp or javascript? or is there a way to select all the text in that textarrea and clear it?
View Replies View RelatedHow do i clear a page of boxes and only allow the last response.write to show? And is there a way to allow the page to show for a while the response.write and then bring it to another page by a certain timing?
View Replies View RelatedIf the user want to log out from the web site, do i need to provide the any coding to clear the session?
View Replies View RelatedIs there any way I can clean the cache at the top of each web page so that users cant use the back button in explorer ?
View Replies View RelatedI need the Clear Button to clear all the fields/values that i have in one of the table in my form. Can that be done?
View Replies View RelatedI have a form submission page that I am using some session variables that are created on the page in order to keep track of the information that they have already inputted - so when they click submit if there are any errors the fields that are correct remain populated.However, I am wondering is there a way that if they navigate away from this one page all the session variables that are created are removed so if they come back to the page they need to re-enter the information?
Something like "on page exit - remove session("name")..." ?
I have an Access database containing 10 Tables with a lot data in each Table. I need to copy the database with no data in another directory. Is there an ASP code or object that allows me to clear data in all Table at once? How can I clear all data from Access DB?
View Replies View RelatedHow can I clear Request.ClientCertificate. When I want clear the session of my digital certificate, I cannot until I close IExplorer.
View Replies View RelatedI am worried of accumulated old cart product selections from expired browser windows or other unforseen events. I am holding selected productID's & quantities & userID & sessionID in a sql table from a shopping cart.
I allow user to clear their cart from a button and also automatically clear their cart on user logon. Also on checkout I clear their cart. I am storing selections with sessionID & UserID so they will be unique,. But does anyone reccomend any other cart selection maintenance procedure i could use,.
The back button that appears on every browser has a list that allows moving back to a specific page quickly, I'm sure you all know the one I mean. Is there a means of clearing said list? perhaps some DHTML method or the like?
View Replies View RelatedI have an image gallery in a database and I display one item at random with each refresh. I also have 2 buttons "next" and "previous" to show next or previous items in my recordset. Everything works well except for the fact that once the user has used either "next" or "previous" it leaves my query string in the url bar:
index.asp?action=previous
therefore, if I click "refresh" it continues to display either the next or previous entries instead of dislaying at random like it should.
How can I clear the query string from the url if the commend comes from the refresh button?
Is there any method to clear a form collection after a post without have to do a response.redirect? I am trying to avoid having the form re-submitted a second time on a page refresh.
View Replies View RelatedI am trying to get a thorough understanding of a code where a addition or
deletion of records can be done from a list of records. For addition part of
the form, data is being obtained from set of input boxes. Code:
I have a problem with DSNless connections. I used the code below but doesnt works.
An error message appears in browser...
<%
conn = Server.CreateObject("ADODB.connection");
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:path odatabase.mdb";
conn.Open;
......
I'm trying to make the following asp code work using a DNS-Less
connection on a windows 2000 server running IIS and ODBC 4.0 driver.
The Access database (odbc_exmp.mdb) was made using Access 2002. The
code works if I set up a DNS on the server under the ODBC drivers.
What I'm I doing wrong and what do I change the code to, to make it
work using DNS-Less connection? Code:
Are there ways to let browser forget about the previous submitted form data?
Or prevent user from pressing F5 to submit the same form again
Or prevent user from presising back on the browser?
Right, which do you use? If your using DSNless, then STOP! It's SLOWING down your code and making it UGLY!!
Why? Lets look...
UGLY!
Which looks better
[vbs]
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("./data/vote.mdb")
[/vbs]
or
[vbs]
"DSN=databaseStuff"
[/vbs]
Its also easier to manage and will cause less typing errors. Think about it, it makes sense!
SPEED
Everytime you run a DSNless connection inside an ASP page the connection string needs to be verified,but a DSN connection is only verified when it is created! Meaning the DSN connection is indeed faster.
I am not sure what is wrong with this code. I have tested it at home, used in on previous webpages, and with previous employers. But I am getting this error at my current employers server: Code:
View Replies View RelatedI've been using ASP.NET for a couple years now and I'm trying to fall back into ASP for a new position I've acquired...and I'm having a bit of trouble remembering. I'm running to a problem where the basic logic is as follows:
Query
Do While Not rs.EOF
Query based on value in rs
Another query based on value in rs
Loop
There is no explicit connection object, they all use the same connection string however. When I limit myself to one query within the Do/Loop, I don't have any problems. However, when I add another query in there, it bombs with: Operation is not allowed when the object is open.
I'm assuming it's referring to the connection string being reused, but why would it allow one additional connection, but not two. I can't really close this connection before needing to requery. Is there anyway around this, or am I missing something entirely?
i am maintaining a system that was developed using dream weaver. a lot of the asp ado code looks like this:
set sp_yellow = Server.CreateObject("ADODB.Command")
sp_yellow.ActiveConnection = MM_MHR_CONN_STR_STRING
sp_yellow.CommandText = "Sp_HPMSQ007_GetSystemConstants"
sp_yellow.CommandType = 4
sp_yellow.CommandTimeout = 0
sp_yellow.Prepared = true
sp_yellow.Parameters.Append
sp_yellow.CreateParameter("@RETURN_VALUE", 3, 4)
sp_yellow.Parameters.Append sp_yellow.CreateParameter("@P_NAME_TXT",
129, 1, 17, "MLSTN_YELLOW_DAYS")
set rst_yellow = sp_yellow.Execute
someone on another forum expressed that dreamweaver "tends to drive the programmer to creat implicit connections and their effect on performance".could someone explain this to me? a provide some better code? (we no longer are required to use dream weaver to develop code for the app).
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 ?
View Replies View RelatedI am programming a rather large site which will hopefully attract thousands of visits per day. I have been told by other people that MS access begins to struggle once it has about 15 active connections.
Since I am currently using MsAccess to test my scripts along with IIS 5.0 or whatever it is, I guess that at some stage I am going to have to convert all my stuff so that the data is in an SQLServer Database, and that the scripts can read and write to it. could anyone tell me what the transition is like. should I consider using SQL Server from the beginning or will I just have to change a few lines on each page.
On my website, I want to provide 3 pieces of statistics that will require 3 queries to my SQL database. As much as I'd like these to be live, they are part of a footer that will load each time for about 10 pages on my site. I am thinking that, although they are simple queries, it may be just too much.
What do you recommend? I could open the connection, run the query and then close it, each time. Would this be a recommend plan? Or, should I create a daily task that builds a simple text file with those query results and just pull those in each time the footer is loaded? This would not be live, but I can deal with it.
I get somthing like "Max Connection limit is reached" error msg when trying to access a page. I wonder it is got to do with winxp pro sp2 patch which only limit 10 tcp connections? Running ms access as database and IIS 5.1.
View Replies View Relatedhow to close all open database connections without referring to each connection by name across an entire server?
View Replies View Related