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 have a Fedora Core 4 server with cPanel which is my master server shall I say. And 2 days ago, cPanel did an update which brutally murdered my MySQL 4.0.25 on the system, so I was forced to upgrade to 4.1.18. So we did that, and all is working now...
Now, my business has satelite servers that revolve around the master server. It allows people to remotely start and stop services on those satelites, and it uses ASP to remotely connect from the satelite, to the MySQL database on the master server to retrieve information regarding the users.
So yesterday, after the upgrade, my satelites seemingly connect to the MySQL server (it does not give an error), but it does not perform a correct query, thus no users on the network can start or stop their services. It just says "Invalid user or server". Now, the MySQL connection is working, because I have other software that authenticates thru the Master Server MySQL database that is working perfectly... I just think it is something wrong with the code on this Activ Serv... I had the program custom written about 2 years ago..
I have tried upgrading the MyODBC driver from 3.51.10 to 3.51.12 and that did nothing to help.
I have the entire code which is right here. Of course it uses a executable on the server to start/stop services and collect process ID information. But the queries are not working correctly so the executable never even runs... Code:
running w2k3/iis6 and trying to shorten the length of time that a simple 10 field ASP form takes to execute using CDOSYS. it takes about 50 seconds each time...and I've no idea why?
any pointers here lads? on other servers the exact same script does it's job in 3 seconds...but not this one?
Uploading from browser to server using Msxml2.XMLHTTP takes a long time about 15 minutes for a 1.5MB file at 37.2Kbps, although it does get there. Is there anyway to speed things up?
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.
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.
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???
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 am facing a problem with CrystalReports for visual basic.Net 2003. I have passed almost through all the problems but still i get a message when i view some reports "Page header or footer longer then a page".
I am using ASP.net with VB and the developing muchien is running windows XP. the program works correctly to my computer but when i transfer it to the server machine i get the error .
The server machine is running windows 2000 server. It has the service pack on it and framework 1.1 with all the updates. Does anyone have a clwe?
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
How do I go about calling a server-side vbscript within a client-side javascript function? What I have is a page heavy on the javascript that has a number of functions, one of which is to begin a visual countdown with an onclick and also open an asp page containing the server-side vbscript, which initiates a wake-on-lan call. I had no idea how to call the vbscript within the javascript function, so this is why I opted for the vbscript asp page "pop-up" via window.open. Code:
I check to see if a certain submission button is asking for removal. If the removal is true, I update a recordset's delete column. This has been tested and it works. However, now I'd like to prompt the user to make sure that he/she wants to remove the record. Here's the code: ....
I have a Client Side Java Script which is supposed to re-load the options on my serverside ASP form.
I have been trying to get the syntax right to assign the Select box on the ASP form to a variable in my JavaScript so I can update the options. Can anyone either tell me if this is not possible or what the syntax should be. Here is some information.
Form Name = AddProdForm Select Box name = subprodline JavaScript Variable = form1
Here is one of the many versions of this line I have tried.
I m writing one code to invoke remote desktop service for given IP address. For that i m using mstsc.exe file to invoke RDP.
I have a no of links to be displayed on the page and on click of link, RDP for that IP should be called. Currently i m using one button to invoke RDP. Code:
I am starting to build quite a few pages that will have tables of data from an SQL database.
I have been building the table rows on the server side in VBScript, but I have been thinking about having the VBScript code just build array variables in the <head> section (or as local variables), and then have JavaScript functions on the client side actually populate the tables when the page loads.
I do plan to do other things like being able to sort the tables in JavaScript code on the client, limit the tables height and be able to scroll the rows, and click on a row in the table, and have the values populate a form. I will also need to be able to export/download/? some tables into Excel.
I am doing login page . (login.asp)As usual it has username , password textbox and a login button .i need to do client side validation for mandatory fields and I need to do server side validations to check for the hardcoded username and password .if it matches i have to redirect to another page(content.asp)