Stream SpreadsheetML
Ok, I'm stumped on something that really shouldn't be this hard. I've
created some cool code to transform a dataset via XSLT into SpreadsheetML
(XML for Excel) and I'm storing the physical file on a file server. Now... I
currently provide a hyperlink to view/save the file, but this won't work
outside the network.
So, I've been working on making this
hyperlink/linkbutton/button/whatever stream the file back to the user. How
in the name of Zeus's butthole do I do this?
So, in simpler terms; how do I take a physical file and stream the sucker
back? Ideally, I'd like this to work just like it does now with the physical
link to the file. Click the link, it prompts you to save/open/cancel.
Clicking Open pops up Excel and looky-looky, you see the file.
View Replies
ADVERTISEMENT
I have a page which streams an Excel spreadsheet to the user. It has worked
fine for 12mths or more, but recently I found out that it wasn't working. I
suspect the problem lies with IIS, but I'm not sure...
When the user submits a form, the page should stream the file to the user -
the user is presented with a standard Open/Save/Cancel dialog, which the
would ordinarily save to their HDD. I have updoaded the code from the live
server to my development machine (IIS5.1) - and this same code works fine.
However, on the live server (IIS6), the user is presented with the dialog
box, but rather than listing myfile.xls, it lists mypage.asp as the file to
be downloaded.I think this must be an IIS6 issue but I don't know what. Some time before
the problem was noticed, work had been done on the live server, but AFAIK
nothing was done that was *intended* to affect this application.
View Replies
View Related
I'm using streams to upload a file. I get an error 800a0bbc write to file failed.
I've looked on support.microsoft.com and groups.google.com.
No luck on what a 800a0bbc error is.
View Replies
View Related
Does anyone know how to create an attachment using a stream in classic
ASP.I can see that it can be done in ASP.Net as per the article below:
Initializes a new instance of the Attachment class with the specified
stream and name.
http://msdn2.microsoft.com/en-us/library/6sdktyws.aspx.
View Replies
View Related
After the latest security update, is it still possible to use adodb.stream
on the server side?
View Replies
View Related
I'm using
file.OpenAsTextStream(ForReading, _
TristateUseDefault)
and then i read some lines.
Line = TextStream.readline
Then when i finished reading it i need to go to the begiining and read some
lines again.But i dont see how to go back to the begining.
I mean, Is there a way to go back to the first line of the file if i
allready read some lines
View Replies
View Related
We have an application, written in ASP, that uses the ADODB.Stream to be
able to open files and write byte arrays to the Response object. If one of
our administrators patches the web servers this application runs on in
Windows Update, I'm screwed, right? You've essentially just disabled this
COM object, for not only its evil purposes, but its useful ones?
View Replies
View Related
The problem is that in XP SP2, the IE instance opened for the vbscript only
page no longer closes when Excel is closed. The user has to manually close
this window. This didn't happen in XP SP1. Obviously there is a security
change, but I have been unable to determine how to reverse it.
Does anyone know how I can get the IE instance to close when Excel closes in
XP2 SP2?
View Replies
View Related
I am using ADODB.Stream for downloading the files on user machine. The code works fine when filesize is less than 10 MB. But if file size is more than 10 MB then it doesn;t get download. Can anyone tell what is the problem. I have to user some different component.
View Replies
View Related
I'm looking to have an image (say, icons for a particular document) and when it is clicked on, I would like the "Open/Save/Cancel" dialogue to open up.
I was told using an ADO data stream was the way to go, making the app an unknown so the dialogue opens:
Dim FileName
Dim FullFileName
FileName = "MyWordDocument.doc"
FullFileName = "C:WebfilesMyWordDocument.doc"
Response.ContentType = "application/x-unknown"
Response.Addheader "Content-Disposition", "attachment; filename=" & chr(34) & FileName & chr(34)
Response.Binarywrite GetBinaryFile(FullFileName)
Function GetBinaryFile(ByVal FileSpec)
Const adTypeBinary = 1
Dim objStream
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Open()
objStream.Type = adTypeBinary
objStream.LoadFromFile (FileSpec)
GetBinaryFile = objStream.Read()
Set objStream = Nothing
End Function
Is there a better way to do this? Also, I grab the file name from a SQL query which is then populated to a datagrid - the image name/etc is populated dynamically - how is this done in ASP? Is that with an anchor tag?
<asp:TemplateColumn ItemStyle-HorizontalAlign="Center"><ItemTemplate><asp:Image ID="thumb" runat="server" /></ItemTemplate></asp:TemplateColumn>
View Replies
View Related
i want to be able to write an asp.net function to download files.
For example, brinkster.com hosting service has a COM component that allows a stream of binary data to the client from the server so that the client will be prompted to download the file.
here is the syntax:
Set Upload = Server.CreateObject("Persits.Upload")
Dim SysFilePath
SysFilePath = Request.QueryString("filePath")
' Parmeters:
' 1. Path to file to download
' 2. Yes, build content-xxx headers
' 3. Use this value for Content-Type header
' 4. Include the word "attachment;" to Content-Disposition to force download
Upload.SendBinary "premfs3sitespremium8jaydakissx22webrootmyFile.txt, True, "application/octet-binary", True
How can I do this in asp.net without using the "Persits.Upload" COM object?
View Replies
View Related
I am trying to create a text file by using the following code. But it's not working. It just loading the page that's all.
<%
DIM fso, NewsFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set NewsFile = fso.CreateTextFile("c: est1.txt", True)
NewsFile.WriteLine("Hello World!")
NewsFile.Close
%>
View Replies
View Related
I am trying to secure .pdf files by having users login and based on UserID, allow access to certaing .pdf's.
I have tried it a few different ways using different file types and their corresponding contenttype and nothing happens. I even used the same example from microsoft.com and I get "page cannot be displayed"....
View Replies
View Related
got stalled at at point that i can no longer get my thoughts together.the point, is in classic asp, stream an excel file from a firebird database.temporarly save it if necessary,stream it to the browser,delete the temp file
on googling, i found some examples but all assuming that the file is locally present.
on the other hand, i beleive that is possible to stream the binary file and the save it locally to then present it to the browser, but i can't figure out how.
View Replies
View Related
I have a page on our intranet that is supposed to stream an Excel sheet to the user.
View Replies
View Related
In Windows 2000 IIS 5 SP3 this:
http://support.microsoft.com/?scid=kb;en-us;276488
is not working. No error but wants to save binary.asp to disk and can't. I have it in a High Isolation Application.
View Replies
View Related
I'm trying to create a page that uploads a file. I get an error message saying ADODB object Stream is not available in my server. How do I upgrade my ADODB library?.
View Replies
View Related
I need to hide my video streaming source URL such as mms:123.11.123.24 est.wmv . I know how to hide image source using another ASP at the <img src=> tag. But what about streaming Video ? Is there a good way to hide it in ASP code ?
View Replies
View Related
I want to know if there is a way to get a chart on some excel worksheet and stream it as a binary png or jpg picture to an asp page.
View Replies
View Related
I have a directory on my site where the users do not have direct access so I need to stream the files throuh an asp file for them to download these files. Like this:
download.asp?File=myfile.mdb
or
download.asp?File=myfile.xsl
or whatever.
The problem is that I dont know the type of file (.mdb, .xsl, .wks, .doc, ...) so I dont know what to put in the header for this to go smoothly. This is some code (that does not work :-))....
Just ignore my code completely if you feel like it... I only need asp code to download any type of file.. Code:
View Replies
View Related
I am using the code below to ensure that a download will be sent to the user as a save/open dialog box and not open up in the browser. However I get one of a few different issues.
1. Sometimes the when you click save the box just dissapears and you never get to choose where to save it. And then don't get the file!
2. If you get past the first problem (seems to be unique to pdf's) and can select where you want to save the file, it then doens't actually download the file and the box just dissapears again!
3. If you get past both of these, documents are often corrupt!
Any idea what could be causing these? The server has MDAC 2.8 installed, and it works slightly better on our local testing server Win2k than it does on the live Win2k server! All very odd! Code:
View Replies
View Related
I`m writing a little routine that captures the data from a form submit (ie a picture) and then at the back end the asp will saved it back out into a file on the server.
I can capture the file fine and display the binary data to the screen.. but now I`m trying to write the data back into a file on the server. After a bit of searching around on the net I found that most people where suggesting using the ADODB.Stream functions.
So this is what I've got but for some reason when I go to write the binary variable it complains. Code:
View Replies
View Related
I am reading a file on the fly..which contains both ASP and html. Is their anyway i can cause any ASP in this Text Stream to execute?
View Replies
View Related
I have an ASP page that downloads file with the ADODB.Stream object.
I've found that if the user click cancel in the "Save file as" window or
during the downloading, the download is no more available, the page hangs
over and and the session have to be closed. (In some cases you have to Cancel
more than one time the download process to rise up this error).
I've experienced this problem, as a user, with many major webmail services
too!
View Replies
View Related
I have a C# Desktop application that collects a set of System.Drawing.Bitmap objects.
Now, i want a ASP page that recieves that set of bmps and displays it as a video stream. Is this even possible? Ive googled but found no reference for this. My C# application continously sends the Bitmap objects, i just need those bitmaps to be redirected to a page that will show those pages.
Update:
A simpler way to look at my problem: I want an ASP application that connects to a server, that server will be sending a bunch of BMP objects, and then display those Bitmap objects as a video stream.
View Replies
View Related
I have an asp page that needs to display the string that is returned from a
cgi file.
As an example, if you enter http://mydomain.com/mycgi.cgi?98127398 in to a
browser, it will display YES or NO
I need to have my asp code query this url, get the resulting string, then
act upon it (basically use the answer to display a nice big tick or a big
cross). Code:
View Replies
View Related
Receive xml as input stream through asp and parse it. I would be getting a xml file and i need to recive it through asp and parse it thus extracting its childnodes.
View Replies
View Related
When trying to load a file using ADODB.Stream, LoadFromFile method I get the following error:
Safety Settings on this computer prohibit accessing a data source on another computer
I'm running windows server 2003. I have the site security set to "Local Intranet"
Any Suggestions?
View Replies
View Related
I use the Stream method to serve certain file types to the user. If the
type is pdf, it opens in the browser fine. My problem is with those
that the browser doesn't have plug-ins such as ppt, word, etc. it
prompts to choose Open/Save/Cancel and defaults the filename to the ASP
page serving the content. ie. BinarySend.asp -> BinarySend.doc,
BinarySend.ppt.
If I use
Response.AddHeader "content-disposition", "attachment;filename=" &
sFileName then it defaults the filename to the name I specify but
always prompt a download instead of opening directly.
Is there another way to default the filename in situation like this?
View Replies
View Related
The following code was suggested by one of the users in this newsgroup when a pdf file was requested by a user from an asp page. I used the similar code in my page and the very interesting thing is when the pdf is displayed on the fly, the whole page is a gibberish code in stead of a normal pdf file. But it displays fine if I just use a link to a file on the page. Can you tell me what's the possible reason will cause this problem?
View Replies
View Related
It involves using ASP/VbScript and ADODB.Stream to read binary data from a *.DOC or *.RTF
file and then send it to the user with Response.ContentType and BinaryWrite.
Everything works fine until I try to Replace() certain strings in the *.RTF
file with my own data. I'm assuming Replace() is choking on the binary characters, or
incorrectly thinking 0x00 values are marking end of string. Code:
View Replies
View Related
A site Im working with has an API that allows one to retrieve files.
The file is a Word doc sent as a byte stream.
url="blah.asp?fileid=777777"
set oXMLHTTP=server.CreateObject("MSXML2.ServerXMLHTTP.4.0")
oXMLHTTP.open "POST",url,false
oXMLHTTP.send
binData=oXMLHTTP.responseText
I am trying to save the stream as a file on the Web server. It isn't
working. I've tried using FS.OpenTextFile, Stream.Write, etc.
Nothing is working.
Anyone have any sample code on how to do this?
View Replies
View Related
I wanna read binary data from database with ADODB.Stream object. So I wrote code..
---------
<%
query = "SELECT * FROM Categories"
adoDB.DefaultDatabase = "Northwind"
adoRs.Open query, adoDB, 1
Set rec = Server.CreateObject("ADODB.Record")
'read [Picture] column.
rec = adoRs(3)
------------
And the 'rec' TypeName() is 'Byte()'
But I can't get it to ADODB.Stream. How Can I do? Or Can I read binary column to another way?
View Replies
View Related
