Web Client Disconnects From SQL Server - IIS Timing Out?
I am having a problem executing long running queries from an ASP application which connects to SQL Server 2000. Basically, I have batches of queries that are run using ADO in a loop written in VBScript. This works pretty well until the execution time of a single query starts to exceed some threshold, which I am trying to narrow down. I can typically run 2 - 10 queries in a loop, with the run time being anywhere from under a minute to an hour or more. Now that this application is being subjected to run against some large databases (25 - 40G), I'm having problems getting the application to continue beyond the first query if it takes a while to run.
I used SQL Profiler to try to diagnose what was going on. I can see the query executes to completion, but immediately after completing I can see an "Audit Logout" message, which apparently means that the client has disconnected. The query durations vary from 45 or 50 minutes to up to over 90 minutes. I have the ADO connection and query timeouts set to very large values, e.g. 1000 minutes, so I can't think its that. My guess is that there is some IIS setting or timeout that I am running up against and the connection to SQL Server is just dropped for some reason.
The configuration is
NT 4.0 SP6
SQL Server 2000 SP3
IIS 4.0
Explorer 5.5
I'm only running into this problem on the very largest databases we run against. The vast majority continue to function properly, but this is going to happen more often as time goes on the databases continue to grow in size.
View Replies
ADVERTISEMENT
I have my asp pages stored in my server ,but when i try and call the asp pages in the clinet side it does not show a portion of the page,the same thing if i call from the server it shows me.
View Replies
View Related
I need to know if, and how, it is possible to use ASP to download a file automatically from the web server to the client in a given path. Is that possible ? Ideally I want a page with a link that when pressed it will copy a certain file that exists on the web server down to the client.
View Replies
View Related
oChart.ExportPicture file_path, "gif", 200, 200
Response.Write "<img src='"&file_path&"'>"
if file_path=/smart/chart.gif
how this code can run in client computer as it will search in the local cmputer
View Replies
View Related
we have some exist file at server site.we wants to open it from any client by simple browse or click on file. is tre any tool to do this or any script.
View Replies
View Related
My boss told me web application is NOT client-server application. I argued
with him because browser is the client, and the server code put in server.
Then web application should be a client-server application. My understanding
is that a web application is an application that runs on a browser. But
client-server application is not necessary a web application.
View Replies
View Related
There is a client and a server. They both share a folder structure that is identical. The client is able to copy and import files to and from the server with button click.
The client is running IIS and some local scripts. The client also has a network drive mapped to the SERVER location.
Is there a way I can copy files without running IIS on the clients machine? The server needs to pass the file info to the Client. Also keeping in mind that I can't get IE to open file protocol links.
View Replies
View Related
Using classic ASP is it possible to get the user's name and password and pass them to the web server to avoid the Windows Authentication popup login box?
View Replies
View Related
At the moment I am building a small news board on my companys intranet. There are 2 different offices with 2 different domains. for each office I want to show different news relating to that office.
Is there any way with asp to get the name of the domain that the user is logged onto so I can filter different news for each domain. This will just save the hassle of putting the intranet on 2 different domains.
View Replies
View Related
I want to know the possiblity and process of an ASP client, which needs to get some UDT from a ATL Server component implemented in VC++. The UDT is basically a C++ class consisting of a BSTR and a short. for eg.,
class CMyClass
{
BSTR myName;
short myNum;
};
and what actually i need is to pass a collection(vector) of this object to ASP client as well as to a VC++ client.
View Replies
View Related
The jist of what i want is the obj.FileExists (how it checks for a file on the server) for the client machine.
The client will be scanning something that will put a pdf file into a shared folder on their machine (it will be the same path for all clients). I need to get the code* to pull that file so that i can take the data on the pdf.
*Code doesn't have to be ASP. i'm up for ASP, VBScript, Javascript.
View Replies
View Related
I want to launch a client application from the server and send it some parameters. The application is written in PowerBuilder.
View Replies
View Related
Normally when I do serverside processing and if the string may contain < or > characters in the userdata I would do:
<%=Server.HTMLEncode(userdata)%>
However if I'm doing client side processing is there any equivalent VB function that I can call to do just that, or do I have to write my own routine to convert < to < and > to >, etc?
View Replies
View Related
isit possible to access variables (code) from ASP server script to ASP client page?? take for example the code supplied below:
'server script
<%@ Language=VBScript %>
<%
dim svalue
svalue="access me"
%>
'client code
<HTML>
<BODY>
<SCRIPT LANGUAGE="VBScript">
dim x
x = svalue 'svalue isfrom server script
response.write x
</SCRIPT>
</BODY>
</HTML>
View Replies
View Related
I was wondering if anyone knew how to determine how to determine the
client's time zone from within an ASP page?
View Replies
View Related
Suppose I load data from a database and store it in a VBScript array using asp (i.e. this is all done from the server)
I then want to have some client side scripts (they have to be client side because they are activated depending on what the user does on the page). Is there any way of accessing the array generated at the server, through the client side scripts???
If not, how else can I write my page?? The data is loaded from a database, which is obviously done at the server. If not by doing what I have already described, how else can i use the database data in my client side scripts???
View Replies
View Related
Let me paint the picture: A large MS SQL database (in 7.0) on a Win2K box (not that the Server O/S matters here really) and an ASP page that grabs data from it to present, of course, to the client browser. For the sake of conversation (since I have tested this oversimplified version of the problem) the code pulls a select * from blah (where blah is my BIG table - right now about 25,000 rows).
The problem/question is the time it takes to present the HTML to the client. The big question is...
Why would it take significantly longer to present the final (parsed) HTML on a remote client computer than right on the server? Note: I would normally consider the time it takes to "download" the HTML to the client, but in this case the actual "presented (parsed) HTML" is so small (it's only one integer inside the body tags), that could never account for the difference in time...and I mean significant..on the server...seconds...on a random client computer...many minutes...on my customer's machine...over an hour (which is, of course, my particular problem).
I obviously have to look at their ISP, but a)Again, the end-product HTML is very VERY small and b)the page does eventually present itself (so it's not timing out). I have the scripttimeout set ridicously high so that potential problem doesn't come up, but that's not the problem.
I just want to know what could be causing the significant time difference? Everything I know about the ASP "process" tells me this scenario should never happen (unless the HTML being sent is significant, of course, like a huge list, or something).
View Replies
View Related
I want to be able to client process of the ASP page to get the value
populated in Request("rssFeed"), how can I do this because the Request
object is not available to the Client-side.
View Replies
View Related
How to download the file from web server to client machine? If anybody have idea, inform to me.
View Replies
View Related
I have a chunk of code, where based on the user's selections, it goes through a database and selects all of the records from the database and writes them to a text file (the database contains nearly 600,000 records), currently, the file is written and the user would end up having to wait for it to be written, before continuing.
Is there a way that this file could be kind of.... tagged or something, so that the server creates it in the background, instead of while the user waits, so the user can continue doing other things, rather then having to wait for the text file to be created.
The files can be quite large, as they can end up being anywhere from 1 - about 600,000 records with between 4 - 10 fields each. Here is a sample of the code that creates the text file. Code:
View Replies
View Related
I did a program with allowed to user to upload an excel file and insert those data into the access database. I did the testing on xp pro and to upload abt 300 records took me less than a minute.
However, the computer which the program is to be located is using windows 98. So i dowlnoaded the free server thingy. The upload time for 300 records here took about 15 minutes. haha
Just want to know what makes the uploading time so different?
View Replies
View Related
Can ASP pull the time it takes for a query to be hit on a DB and returned?
I see outputs like :
"6 results, query took 0.24 seconds"
I know the "6" comes from a record tally, but how can I calculate the time?
View Replies
View Related
I have been tasked with producing a script that times the amount of time it takes to upload a file from client to server.Unfortunately for me, part of the spec is that the script must be written in ASP which is something I have about 30 minutes experience in.
I have been playing around with the script located at this address :
http://www.asp101.com/articles/jacob/scriptupload.asp
Which does almost everything I need, the only thing it doesnt do is tell me how many seconds/milliseconds/widgets it took to upload the file to the server (excluding time to write to disk once received)Can anybody point me in the direction of another script that can give me timings, or at least give me some pointers on how I can hack the above script to give me the data I need (I have already worked out how to get rid of the save to DB and user name option and this is now gone from the display page and the working scripts behind it)
View Replies
View Related
Is it possible to put a time counter on a page which say after 20 minutes will automatically terminate the session using the abandon function?
View Replies
View Related
I open a asp page where the user fills in some details in and submits the page. The form will be submitted and sent to a diffrent page, it will check and return whether the transaction was successful or not.
This is a timebound process the time starts as soon as the form get loaded. Suppose the time is 10 minutes so if the user fills in the form and submits the form. We would consider the transaction successful if we receive notificaton of the transaction being successfully completed within this 10 minutes limit, if it takes more than 10 minutes than we consider the transaction to be unsuccessful.
View Replies
View Related
I want to call a procedure 20 minutes after the page loads in vbscript. Could someone how to time the page?
View Replies
View Related
I have a piece of code that i created. It actually works as it should. The only problem is the objrs2.update causes an error-duplicate primary key. However when i check the database it has done what it should.
I then tried to use on error resume next, but it keeps timing out and i do not want to extend the time limit. Does someone know how to get round this? Code:
View Replies
View Related
I'm having a problem where I'm losing Session variables as soon as they've been set up. The user logs onto the system, the system sets some Session variables, and redirects to a menu page. The menu page checks the Session variables, can't find them, and asks the user to log in again - the second login is successful. Has anyone seen this before, and do you know what I should do about it?
View Replies
View Related
I have a small (half a meg or so of source, and a 2.5MB database, and a few images) ASP web app in place, and it's running fine except for the fact that occasionally people have session timeouts and are suddenly not logged in.
I've turned the session timeout in IIS up, but they still seem to get logged out in less than 15min, rather than 2 hours, as intended.
View Replies
View Related
I usually clean the session when the result page is presented to the user.
At this time, say an email confirmation was sent to the user and a pdf file
they can becdownloaded from the result page.
But if the user click the refresh or back button etc. for some reasons, they
pdf file is not available since it created on the fly when the request was
submitted.
So I am thinking about pull pdf file from database, but don't want the
database being hitted everytime the refresh button was clicked or the
requested is resubmitted.
View Replies
View Related
is it possible to open an excel file (used as a template) from server using server-side vbscript; then modify it or add values from client using client-side vbscript?
View Replies
View Related
Following is a vbscript code extract triggered by a combobox OnChange event. arrVendorA and arrdefpack are server side arrays and i need the intCounter parameter to be the array index. Code:
<script>
sub getstdPackByVendor(strPartNo, intCounter)
dim selVendor
selvendor= colSelect("cboVendor", intCounter).value
if selvendor= "<%=arrvendorA(intCounter)%>" then
if "<%=arrdefpack(intCounter)%>" = 2 then
colTD("txtStdPack" & intcounter+1 ).innertext = cstr("<%=arrVAStdPAckL2(intCounter)%>")
end if
end if
end sub
</script>
View Replies
View Related
The following code is giving me a type mismatch error at the 'if' statements... any ideas, anyone ?
sub getstdPackByVendor(strPartNo, intCounter)
dim selVendor
selvendor= colSelect("cboVendor", intCounter).value
if selvendor= "<%=arrvendorA(" & intCounter & ")%>" then
if "<%=arrdefpack(" & intCounter & ")%>" = 2 then
colTD("txtStdPack" & intcounter+1 ).innertext =
cstr("<%=arrVAStdPAckL2(" & intCounter & ")%>")
end if
end if
end sub
View Replies
View Related
