Closing DSN Connection
I just want to close my dsn connection. I cannot seem to find it. is it Set conn = Nothing?
View RepliesI just want to close my dsn connection. I cannot seem to find it. is it Set conn = Nothing?
View Repliesfor readability purposes,I plan to standardize all my asp pages to always open connection at the beginning of the page and close the connection at the end of the page
If in the middle of the page I issued redirection,does this mean the connection will not be closed?
If I use response.redirect, is the entire page read before the page is redirected?
For example, assume I have this code where the response.redirect is located before the objConn.Close line:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "sampleDSN"
response.redirect("default.asp")
objConn.Close
Set objConn = nothing
Will the page redirect before the database is closed?
If I use response.redirect, is the entire page read before the page is redirected? For example, assume I have this code where the response.redirect is located before the objConn.Close line:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "sampleDSN"
response.redirect("default.asp")
objConn.Close
Set objConn = nothing
Will the page be redirected before the database is closed?
I created connection to the Microsoft Access DB using DSN from my ASP page.
<%
Set vpconn = Server.CreateObject("ADODB.Connection")
vpconn.ConnectionString =
"File Name=c:inetpubwwwrootDBDNAME.dsn"
vpconn.Open
' Close connection immediately after opening for testing
vpconn.Close
Set vpconn=Nothing
%>
The Microsoft Access, for every database opened for shared use, creates an .ldb file to prevent users from writing data to pages that other users have locked. Whenever the last user closes a shared database, the .ldb file should be deleted.
It is working; the .ldb file is deleted immediately after closing connection
but not if you open/close this connection from your ASP page.
What I found, the .ldb file is deleted with about 70 seconds delays after closing connection from an ASP page.
today i got an error from my site
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed
it got error when i tried to update.then i checked all my files which has database stuff.i did not see any close statement for recordset & connection.we used DSN for connection.this site was build my someother firm.when i asked to my boss he told me they kept connection open purposely becoz they had uesd connection pooling.they said using connection pooling can utilize less memory resource.should i close each & every open recordset & connection
I realize that sometimes you can use recordsets that were never opened (like when you're adding a record to a db) and I realize that you cannot close a recordset such as this.
But for the ones that ARE open, should they be closed first and then set to nothing?
Also,I'm trying to create code that checks if a recordset is open. If so, I wnat to close it. How would I do that?
In my code I am opening a new window through javascript which opens upon submitting a form. The form collects certain information from user ; and this information is used to create a file.This file is created after the page is submitted and just after the file is created I want to destroy the window and then give a link on the page to download the file.
Is there any way to do this. The problem I faced was upon submitting the page I loose the window object that is returned by window.open method.
I have a page on a server (not under my control) that can't have scheduled tasks running on it and I need to hit the page once a day. I am currently doing this through a .bat file on our server which runs iexplore.exe and hits the page. Is there anyway I can get this window to close? either though the .asp page or in the .bat file.
This is becoming more of a problem as there is the likelyhood that within a month or so, I may have more pages requiring this same operation and it isn't very good to have to log on to the server each morning just to close these windows.
I have in the back of my mind and knowing the importance of using close(rsname) to close a recordset once it has been finished with, is whether any recordsets have been left open accidentally.
Is there, therefore, a way of listing all open recordsets, without specifiying the name of the recordset? ie. "For each key in recordset". Do recordsets get closed after a period of non-use?
Is there anyway to close a browser without getting the "Do you want to close this window" pop up? I intend to launch a browser using the windows scheduler. And auto close it itself. I tried using self.close() ...but got that pop up confirmation. Anyway?
View Replies View RelatedWhat's the proper syntax for determining if a connection is open before closing it?
View Replies View RelatedI have a button that goes to a new page - if a person clicks on the X in the right hand corner - I want it to go back to the previous page. How do I set this - I can't set the target to blank.
View Replies View RelatedMy website has been targetted by a web scam. They have sent out an email, which looks as if it's come from me (the email tells them that they must update their information). There is a link in the email which, when clicked, opens up 2 windows: my site in the background and a small window on top with form. This forms asks the customer to submit sensitive information. Is there any script I can use to close down other windows when my site is opened? I can't think of any other quick solution at the moment.
View Replies View Relatedhow to close an asp application. What is the ASP code i should use to close the browser Is it something like "window.close".
How can I close the window (DownloadCSV.asp) automatically when this has asp page (GenerateCSV.asp) has finished loading. The asp page, GenerateCSV.asp is called in the onLoad event when it has finished it pops up the download dialog box, when that happens I want the page that calls it to close, how do I do this??? Code:
View Replies View RelatedIs it sufficient to Set a Connection or Recordset to Nothing, or ought they
specifically be closed first?
E.g.
Set rs = oConn.Execute(sSQL)
'Do stuff
Set rs = Nothing
Set oConn = Nothing
I am trying to close a command object after executing a command text and getting an error message as:
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'close' /data_usage_guide/workplansystem/ProjDataLoad.asp, line 67
The reason I want to close the object is to use it again for executing another commnad text as shown in the code below. Could any oen help why I am getting this error message and/or is there a better way to do this , i.e. posting data to several diferent tables one after the other. Code:
I have a submit button which opens a child window,and submit parent window to itself and then begins some processing on parent window. On completion there appears close button on parent page.
Can anybody suggest me how to close the child window on the click of close button on parent window and then redirect to other page?
I realise that all database and recordset objects must be closed and set to nothing, but I also use other objects but I can not find any mention anywhere whether it is important to somehow close and set these objects to nothing. The objects I am reffering to are the aspupload object (www.aspupload.com), the command object and the parameter object that you can create using a command object...
View Replies View Relatedif i run my project IE will open and output willl be shown. my need is u can able to see three butons(minimize,maximize,close) in yhe right corner of the IE window, me need is that should not be appear so only screen will be displayed.why i need this requirement is user cannot close teh window using any method, one method is this pressing this close button, i need to block this
my second need is if try to use alt+f4 to close the window i shouldn't close for ten minutes,after ten minutes he can use alt+ f4 to close so please give me coding for this also
third way is if he tries to use windows+d or windows+m or alt+tab it should not work,i need to block this way also
i'm tring to solve out how can i pick the moment when user shot-down the window and to do some operation. i made a real research and tried all kind of stupid creative crazy and long ways to do this. the solution got to run on average pc with internet explorer 6+ and with popupblocker.
i'm running my files on brinkster.com...they do not support scheduale tasks.
-global.asa ,session_onend never shoots... disqualified!
-popups blocked... disqualified!
-schedualed stored task not supported... disqualified!
When i select a order ,a new window opens up .I select the name from the new window .This window also has a submit button(there is a insert statement which gets activated on submit).
wht i want to do is when i hit submit ,the window should get closed and should be redirected to the previous page from where i actually got this window i.e by clicking on the order at the start. how should i attain this?
I have a question regarding opening and closing a particular section in a web page. I have done that in .net using panels, but, I dont know how to do it in ASP (using VBScripting, JavaScripting).
I have a table with long list of users and every user has some info attached under them. My table looks too long. I wanna give my users a functionality in design so that they can close and open each section. Is there a way to do it in ASP?
I tried this code below and there is a problem in the code which is not closing the word instances in the server you can see that from Task Manager
STEP 1:
Code in test.asp.
<%
Set word = Server.CreateObject("Word.Application")
word.Documents.Add
word.Documents.Open(Server.MapPath("test.html"))
word.Documents(1).Close
word.Quit
Set word = Nothing
%>
STEP2:
Create a test.html in the same folder.
Execute the code in the server
http://localhost/test/test.asp
Is creating the 2 files WINWORD.EXE instances in TASK Manage every time we browser the test.asp page. This is creating the load on the server and making our application DOWN. I am a coldfusion developer working on ASP.
I have an ASP page that runs for at least 2 mins. What the user sees is a progress bar as the page is completing execution of scripts so they know that something is being processed.
The ASP page can be quite CPU intensive and I've found that if the user decides to close the page the CPU usage does not appear to drop back to its normal levels whereas on sucessful completion of the page the CUP usage does drop to normal levels.
Now I know that after a while the CPU usage does drop to its normal levels, however, I'm weary that this could be a long time if there are simultaneous access to the same page.
My question is, is there a way of controlling this via scripts? ie. can I force the webserver(iis) to timeout the script sooner or is there a way i can kill the instruction been sent...
I have an important question to ask about how to trap events when the user close the browser window.
I'm a ASP programmer and I have s MSSQL database with a user table where I'm able to track if the user is logged in or not.
However this is not easy to track if the user close the browserwindow without using the logout button. I have tried putting in code in Session_onend, but it doesn't seem to run if the browser is closed. Eg. tracking visitors in a application variable in Session_OnStart and Session_OnEnd. Code:
I am maintaining some code and I see in some functions..
Function myFunction
set someobj = Server.CreateObject("MYOBJ")
.....
....
set myFunction = "somedataToReturn"
set someobj = nothing
End Function
Iam trying to capture windows closing event (i.e) when the user clicks
on the "X" button i want to capture that event and want to update some
values in the database.I tried two methods but iam getting problems
with the two methods. Code:
I recently installed IIS lockdown, and ever since my ASP pages have been hell. One problem is that now after a user views my ASP page which reads my local Access DB, the temporary file, .ldb, stays in the folder forever!
This temp file is created when a user opens the file, so I checked out the .ldb file and it says the ADMINISTRATOR is opening the file! How can the internet user be using the ADMIN account?! This is not good news! I will share my code for my page; however I have a feeling the code isn't the problem, but a setting is. Code:
1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
I wanted to know wheather DSN is ok for the connection to a database or direct conection is better?
when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering
is this going to have any affects when i uplode the complete site on the server.
i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.
i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
I am trying to create a web page that has a drop down menu in which it retrieves data from our SQL server. Maybe this is a bit more simple than I am making it but I am really pulling my hair out trying to get this right. Code:
View Replies View Related