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.
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.
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.
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.
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.
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.
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?
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.
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.
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.
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?
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???
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).
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.
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:
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?
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 :
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)
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.
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:
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?
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.
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.
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?
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>
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