I have an VB ASP page that creates, using a linked database, ad-hoc queries. Like, the user selects what table to look into, what fields, any criterias (ex: PROVINCE="QC"), etc. That part is easy.The problem is, I would like the results to be outputted in MS EXCEL. Well, it's not my idea, but I have to do it. Any ideas how this can be done?
My only idea would be that:
1) The ASP page writes to a file on the server and offer a link to the user to download that file.
2) User Downloads
3) We can't have these Excel files cluttering up the server, so the file would also have to be deleted automatically.
Is this even remotely possible?
I'm not too good with ASP, so is it even possible to write to file? Could I create a Workbook/worksheet object using VB ASP?Can I delete the file programatically
Previously I have canvassed a few way to get a registration code from one server to another - checking the results of the search and returning a function in a string tro be executed at the end. Well that worked until one of my beta testers decided that he would fiffle and get around the syste mmm...
I have an FTP server that I use to store documents. When a user needs to download any document the "download link" directly points to the FTP server (eg: <a href="ftp://some URL since URL are blocked">Download</a>). I want to avoid this and now have added a user name and password to the FTP sever. But instead of giving the link as "ftp://usernameassword@myftpserver.com/document.xls, I want a much secure way of letting the user download the file without letting the user know about the FTP server username and password.
I need to log how many times one spesific file is downloaded from my website. First I thought this could be done simply by routing via a script that count number of downloads, and then redirect to the spesific file. But this soultion will not work when a user right click on the file/link and choose "save target as...". How can I solute this?
I have an Access db with usernames and passwords set up on a web site. Upon signing in to a password protected asp page which contains a link to an exe file, the user clicks the link and the browser asks to either Open or Save the file.All this works fine, but if the user simply types the full path to in the address bar, the browser again asks the user to either Open or Save the file - thus bypassing the security Is there a way to prevent this "back door" of accessing the file or would I have to set up an FTP mechanism.
Is it possible to log a successful/unsuccessful download in ASP? I've got a download logging system but I'm wondering if its possible to find out if a download was disconnected or not?
I want to provide the ability to download files from a web page based on whether a user has paid for the file. I therefore need to hide the URL from the user.
How do I write code to download a file and hide its URL?
Is it possbile can we add a new user to domin server thorugh ASP
eg: i have domain server i want to add a new domain user . its in windows .. but i want to give a webpage to sysadmin they can enter only username and user id and some fields .. after that they give create that time in server i want to create a new user . with this all info .. isit possible though ASP ???
I have to get data between two dates. That dates user has to provide and in a specific format like dd/mm/yyyy if SQL server date format is same then no problem but if SQL server format mm/dd/yyyy then I am getting error.
Does anyone know of a way to be able to take 10 urls which point to zip files and then for it to download them one by one, i.e. when one has finished to then begin the next one.
This is for an asp site which is why i posted it here, but i am not sure where to post this as i dont even know how to go about doing it.
I have a website setup which also provide ability to download latest version of our Software by logging into the webpage. All latest softwares (ONLY ONE FILE .EXE for each Software) are located in the "/Download" folder of my website. Customer will login to website and the ASP page decide the software that this user has purchased and privide ONLY that Hyperlink to download the latest Version file.
My problem is if somoe body know the path and file name then they directly put the URL in address bar and will get latest file. How do I restrict that? Please suggest all possible solutions.
A big problem with most server statistics is that when they count file downloads, they are counting the number of requests to the server, not complete downloads. Is it possible to count downloads more accurately?
I can use the Response.IsClientConnected command immediately after streaming the file to the browser but it's working only for files with size less then 80MB . How can I resolve this problem?
I have a file that SHOULD only be made accessable to registered users. They must login to get to the download page. The problem I have is that once a user logs in an gets to that page they can potentially share the web link to that file with anyone and that unregistered user can bypass logging in.
I was thinking something along the lines of download.com where when you click download, the actual files location only appears for a split second, pops up the download box, then it switches to another webaddress?
We have an intranet which is personalized using a cookie which we set. I have an outside vendor who is developing an application which will live on a seperate server. Is there a way they can read the cookie which we set to log user into their application so that we can make it a seamless transition?
I have a website that (like many) allows users to download large files. Some are up to several hundred MB in size. The problem is that since switching to IIS 6.0, the size of the file is limited by the ASPBufferingLimit, and it's size seems to be limited to only 4294967295 bytes.
That's pretty big but it's not quite big enough and I need to disable it. Some people have recommended setting it to -1 via:
c: cd C:inetpubadminscripts cscript adsutil.vbs set /w3svc/1/aspbufferinglimit -1
but the -1 doesn't really "take"...IIS keeps it at 4294967295.
Setting it to 0 does "take", but then IIS returns nothing (0 bytes).
How do I disable or workaround this security feature in IIS which is not allowing people to download large files?
I currently need to allow users to download a series of Excel files from the intranet which were generated individually using ASP. Rather than have them click one link at a time to download only one file, I want to find out if it is possible to let them download the whole series of files with one link click.
The users are all on the LAN so bandwidth is not an issue. Furthermore, the total size of all the files is only 100kb.
We have a server side application that should be able to print to network printers. The problem: How can I setup printers for the IUSR_SRV-... account in a way that I can use them from a .NET webservice?
Is it possible to create an ASP page that can notify the user that they have an email on our Exchange server? And that will list the number of unread emails they have waiting in their inbox.
I need code to capture a users ip address once they agree to a disclaimer (a form yes/no). If the user states no a message telling them they do not have access and a redirect back to the home page.
I need to put the ip address along with the date a sql server database. I am lost as to how to code this and also how to set it up in my directories.
How to select query according to User Input for a WebPage in C#.Net with SQL Server 2000.I am trying to build a web page in C#.NET with SQL Server 2000 using Visual Web Developer 2005. I want to select and execute the query according to user input.
I have a form which has 2 textboxes which gets start date and end date from the user. Based on start/end date my 1st query runs. Now if user does not enter any start/end date I want to run another query which takes default dates from database(which is in varchar:ex. now()/now()-180) according to logged on user's permisstions.
I have written an ASP.NET 2.0 application that uses Active Directory or ADAM to manage account users - the site has a page that allows people to create an account (much like any site). The page populates the AD with all the information and the user account but I am unable to enable the account. Microsoft has information on how to do that here --> http://msdn.microsoft.com/library/d...ting_a_user.asp (the sample is for Visual Basic) - and I am unable to complete the bottom portion of the script. Can some one point me in the right direction - or can you tell me how I can add a snippet of VBscript code to an ASP.NET page.
I am using the Active DS Type library - not sure why there are multiple ones (System.DirectoryServices) but it is rather confusing - I seem to accomplish one thing with one and another with the other (they did have trouble co-existing however). Anyway my script works very well but I am not able to access the properties required to enable the account.
Here is a simple version (no error checking) of the code.....
how to go about setting up an asp script or flash action script to take the input from a user of his/her username and password then send an email to the user with the information. I am able to do all of this but the problem is that the users pc is the one sending the email. I want the server to send the email instead.
I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _ "Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.
I can login with EMS lite both with sql server Auth. and windows auth.What is fault?
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;
I need to read a SQL Server table into a Web Page and within the Web Page to permit my users to make changes to the records, delete or add new records and then save the entire contents back to the SQL Server table back.
The functionality I am looking is almost the same as In the SQL Enterprise Manager whereby I can choose a table open the table and then return all rows and I can maintain the same and save it back to the SQL Server table. I want almost a similar web interface to such a functionality.
Even if not a generic functionality as the SQL Enterprise Manager table maintenance appreciate if somebody can share the code with a sample how I can do it in ASP pages + T-SQL if need be.
I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.
