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?
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?
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)
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 RelatedI 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 want to call a procedure 20 minutes after the page loads in vbscript. Could someone how to time the page?
View Replies View RelatedI 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?
View Replies View RelatedI 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.
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 need to add the functionality to upload an image to the webserver, store it in a folder and add its location to a database so I can find it. I have no idea how to get started on this though. Does anyone have an idea of how to do it or can point me in the direction of a good tutorial.
View Replies View RelatedI am trying to use the upload file feature that comes with Sun ONE ASP but cannot find any documentation on how to use it. As it is a former chilisoft product all the knowledge base documents, FAQ's, and basically all the useful stuff has been dumped by Sun.
Does anyone know how to use this feature or know of any sites where it is explained?
Please don't say "look on the Sun website" as I have been doing that all afternoon and can't find anything useful on the whole site!!
1. I need to upload a text file (Word or txt file) to a server
2. Save the path of the uploaded file on the server to Access database
3. And then display the link of the uploaded file path in the Access database on asp page
i developed website, in that i have one two asp pages one page to collect the data's and other is the confirmation page In the local host it runs very well but i uploaded the webpage the datas i collect could not be stored in the access database
error:
http 405 resource not allowed
my project consist
1 index page
pages folder (all the static pages, asp pages and access database)
images folder
i specified path as
path1= Server.MapPath ("db1.mdb")
My client wants me to add a functionality which would enable him upload and resize the pictures. His server is having ASPUPLOAD and e-kov components intalled. Also he doesn't want to write files to the disk and save only to memory.
I can use ASPUPLOAD's functionality to save files in memory or save files in the database. My question is how can I access a file so that I can resize the image using e-kov software. And when using 'upload.save' only, without path, it saves the file virtualy but where does the file and how to access it.
My form with a upload photo function is not working - Can some one please take a look and see were I have messed up. The code is 4 sections : The Form, The DB script, The submit Script and the Upload script. Code:
View Replies View Relatedi know that this thread allready exists buti still don't understand what to do ... i'm using microsoft frontpage and access database and would like to upload image file to access ... so ... it looks like that:
i have one page - on that page there is an upload form which leads to another ASP page ... on next page i would like to call that form from the previous page and then store it to the database (if it's possible i would like to do it without any software - because i'm not the owner of the server) ... Code:
I have an application that works fine in Windows 2000 IIS, uploading files of any size to a server folder The same application installed in a Windows 2003 IIS limits the upload size to approx 200 Kb, trying to upload larger files generates an "Operation_not_allowed" error in the web log
I suppose that Microsoft introduced some limitation in either the new OS version or IIS but I'm not able to find any reference, except for the 4 Mb limitation in .NET, but it's not my case.
My image is in local directory. Using "FILE" input type, I am getting the path of the image. How to upload this image to my server using ASP?
View Replies View RelatedI've got an application that allows users to upload a
file to a directory.
The problem is some users (5-6) can't upload .doc files.
They can upload anything but .doc files. File size is not
an issue.
What could ever cause that????
I'm creating the Intranet for my company and in one of the parts of it I want that users to be able to upload and download files, however, I'm not sure what would be the best option/application to use for its creation. I need them specially for the uploading to be able to track when was the upload done, which user did it, and so on.
I have been using ASPs to create the website. Could I do this with ASPs ?
Need some help on the following problem:I have to upload an image using ASPUPLOAD component and process other information regading products also in the same form.
What I tried is putting a Frame (using iframe) in the form,
which leads to Upload.asp.
Image uploading goes fine but I cannot find a way to get the
file name or any other value(after uploading) to the FORM in which
this frame resides.
I will need some value to link the image and the product.
Kindly let me know if there is a way to pass values OR a better wayout
for what I am trying to do
Is their any way of implementing an Upload section on my site that can upload a folder with images in them, insdead of just images..
View Replies View Relatedhow I can upload a file to
the server, and overwrite the existing file if there is one.
Is there a way to code image uploader without using dlls like aspupload?
View Replies View RelatedI have a pdf file on an IIS server and I would like the user to upload it on to their computer from the server website.
View Replies View RelatedIs there any way I could upload a certain file whether it is contained as an executable such that when I do a form submit, it can perform the same task that CDO, CDONTS, or JMail could do but without requiring the web hoster to register the dll files to their servers
View Replies View RelatedGuys how do you check if the file uploaded is an image?
I tried this but it seems that it won't work for a form with ENCTYPE="multipart/form-data"
...some code here
If LCase(right(strPictureURL,3)) <> "gif" and LCase(right(strPictureURL,3)) <> "jpg" Then
Response.Write("Error: Invalid File Format!")
I have this ASP code, for uploading files. I can upload an image,but cannot retrieve other form element data, can anyone suggest me a way out?
For eg, I have a form wherein I am getting some info from the user and he needs to upload an image as well. The code I use can upload the image but cannot get the other info. form the form fields. The code to upload is: Code:
I am using some free Upload code by Jacob Gilley:
''***************************************
'' File: Upload.asp
'' Author: Jacob "Beezle" Gilley
'' Email: Join Bytes!
'' Date: 12/07/2000
'' Comments: The code for the Upload, CByteString,
''CWideStringsubroutines was originally
''written by Philippe Collignon...or so
''he claims. Also, I am not responsible
''for any ill effects this script may
''cause and provide this script "AS IS".
''Enjoy!
''****************************************
However, it takes a really long time for it to write large files to
disk. I am uploading files that range from 500k to 2.5 megs in size.
It can take Jacob's code up to 2 minutes to write the file to disk.
Should I just buy one of the upload controls? Are they any faster?
Is there a script out there that will allow me to upload .mdb files. I am trying to be able to let my client go into thier admin page and download the .mdb file (that works fine...) and when she is done changing it or w/e she wants to do with it she will need to upload it to make the changes work. So it needs to over right the origional or something like that...
View Replies View RelatedDid 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