I don't know how to upload word doc, images and other files into Oracle Blob fields with binary format.
I tried with the following code, normally it's inserting, suppose if i try to convery binary. Code:
I am currently working on a document management system for my company's Marketing department. They wish to be able to upload files to the server.
Rather than deal with the many permissions issues we have had in the past with saving and deleting these files to the server's file system, this time we are trying to use SQL server BLOB fields to store the files.
The premise is simple -- a user clicks on the link and the file is then shown in the browser. The documents are mostly word, Quark, and Adobe Illustrator documents. I was thinking the code would go something like this: Code:
I'm searching some code samples that using blob data type with asp.
View Replies View RelatedI am feeling it tough to retreive a image(blob) from oracle to asp.
I am getting an unspecified error while running the select query.
Could anyone please let me know how to retreive a blob from oracle 9i to ASP.
How would a guy go about inserting BLOB files into an Oracle database? My company wants me to put logos in a database, and then depending on the client logging in, display a certain image. My boss wants an interface to allow for us to upload them to the database, also.
I personally think just dropping them into a centralized directory and then storing the path, or the image name in a char or varchar field would make more sense, but. Can someone help me with this, or give me any ideas? I've floated the idea to him to buy a third-party component to facilitate the upload, but he's not really appreciative of that idea.
What about .NET? From what I understand, it has very good file upload capabilities. I already have the framework installed on our server, so I should be able to use it if needed. Would that be a better route to go?
i'm tryin to develop a webpage using classic ASP wherein the user can upload an excel sheet into an Oracle db table with the excel columns correspondin wit the oracle table columns.
i hv come across many ready made libraries/solutions that almost serve the purpose but they didnt work for me since most solutions wud populate the entire excel data into one column of the table. I wud like to know if anyone has a solution tht im lookin for specifically.
when the user clicks on the edit account_details link, a web-based form page opens with text fields like account_no, account_name, date, type etc.
the design i want to implement is when the user enters the account_no field on the form & goes to the next field, the remaining fields on the form should be auto populated with the respective data for that account_no from the Oracle database.
Next the user can edit any of the form fields & save it back to the db.
Has anyone else found a memory leak using ADO streams to access binary data held in a database. I have searched through this forum and have not come across anyone else, so maybe it is just me.
The scenario is as follows:
Windows 2000 SP3
MDAC 2.7 SP1
IIS5
MySQL 3.23
MyODBC 2.50
If I query the database and do a response.binarywrite everything works fine and no memory leak. eg. response.binarywrite myrecordset("blobfield")
If I read the very same BLOB field into a ADOstream I then get a memory leak in DLLHOST.EXE of how big that binary field was. ie If the picture is 140k in size DLLHOST.EXE increases its memory size by 140k.
This keeps on happening until DLLHOST.EXE is something like 250 MBytes in size at which point it stops working. Quick restart of the IIS Web service and I get all my memory back.
The command I am using to get the data into the ADOstream is picturestream.write myrecordset("blobfield")
I have also tried putting the binary data into a variable first before inserting it into the stream:
set x=myrecordset("blobfield")
picturestream.write x
The stream is closed and set to nothing at the end of processing. Everything is cleanly shut down. Through testing I know the memory leak occurs once the data has been written into the stream. The stream is correctly created as type binary.
The stream problem I am encountering does not seem to be limited to ASP, I tried it using Visual Basic to create a COM component to do the same job and still got a memory leak.
So the questions are:
1. Has anyone come across this before or fixed it?
2. Is there another way of getting binary data out of MySQL, something like the opposite of LoadFile?
I have wasted so much time on this problem but cannot find, having searched Microsoft's knowledge base and the rest of the web, any reference to the problem.
when I tried to run my ASP,I'm getting an error and to fix it, I need to run the configuriation file.but tnsping is not installed proper it seems.So can any one plz tell me the procedure to regenerate the oracle control files on WinXp?
View Replies View Relatedhow I can upload a file to
the server, and overwrite the existing file if there is one.
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 RelatedI have one Server that supports ASP, but very little storage space on that server.
I have another Server that supports only PHP, with lots of space.
My website is writen in ASP, so all my ASP files are on the first server, and I have an option on the ASP server to upload files to it from an ASP page by users accesing a certain page.now, I wondered if it is possible to upload files by an ASP file located on the first Server to the PHP server, because there I have more storage, is it?
I need this done this way because once the file is uploaded by the ASP page the file name,size and type are inserted into the DB thats on the ASP page.
i found this code on the net that allows me to upload a file to the server:
http://stardeveloper.com/articles/di...1042501&page=1
The code works really well. However, i want to upload two file at once rather then one. I have tried changing the code but nothing really seems to work. Can anyone see a good way of using this code to upload two files?
I'm making an intranet application where all the users can send mail and attachment to the adiminstrator. Physical file transfer to server machine and putting the message in Access database is done.
I want to upload all the messages along with the attachments in the Outlook of server machine. So that when administrator starts Outlook application, all the incoming mails from intranet are displayed in his inbox. I'm using Access and ASP (VB Script).
I have problem in uploading files using ASP, can you give me some sample code about uploading using ASP?
View Replies View RelatedI use an .asp file to upload files from my website..but there is a problem.
first of all i use a file control and then i sumbit the page using a submit form button
and the asp stores the file it self.THe problem is that if the file is >than 1 mb i cant
i have a free account at brinkster.
and 1mb is the file limit.BUT not the database limit! so i add the file SUCCESSFULY in the database and retrieve it also successfully.THe problem is that i cant send over 1mb over asp. IF you have anyideas or have to suggest any free site that supports that.
I am uploading some files to web server using clsUpload component. The problem is its working perfectly with IE but failing to upload in Mozila, Opera etc like browser. Can any one help me in this. Am attaching the file as text file. These are the 2 asp files.
Kindly suggest me asap as am trying to solve the issue from last 2 days without any result.
I would like to know how can I upload files on a web server, without using FTP, but using ASP.
View Replies View RelatedDoes anyone have some code examples to upload image with ASP. My App is using ASP with VBScript.
View Replies View RelatedI have a page with only one <input type=file ..> tag.
The page submits to itself with a "Save File to List" button. User browses thru the files and click the above button to add the file to a list. In the end user clicks "Submit" to upload all the files from the list to the server.
Problem # 1
I'm not sure how to save FILE type object collection/array, with every click of first button.
Problem # 2
How do I post that collection/array varaible when submit (2nd button) is clicked.
Is there any SCRIPT that I can upload 50MB files? The one I have written do
only <2MB, We have no way to use vb com.
I want to upload files from my page. (in the past I have used pure asp upload) My client is concerned about security. Is there a way to encrypt these files? Is it necessary or does it even help to put ssl on the site. What do I have to worry about as far as security so others can't get to these files?
View Replies View Related
I am currently developing a download centre for a hardware manufacturer which has alot of firmware and other software available to it's clients. Most of these are less than 10mb and with their internet connection I'm thinking a browser upload through the admin tools will be fine. However there are files on the current site of up to 100mb, how would be best to handle uploading these?
I was thinking maybe an ftp component would handle bigger files better than an normal http upload? Does anyone know of any components that allow some kind of background uploading so they can continue to use the admin for other tasks while this continues?
Or just any other suggestions full stop! Maybe I would need to come up with some way of taking them out of the system and loading a windows ftp with the correct directories etc.. predefined?
I have a file upload script that has successfully uploaded files,although the MS .docx format will not load for some reason. Has anyone found a workaround/solution to this?
View Replies View RelatedHow to upload multiple files and zip them dynamically on the fly and store them in a BLOB object? (using asp)any idea about Winzip command line utilities ?
View Replies View RelatedI have recently created a "page generator" for my website - it basically takes a form output and sticks in some html etc etc. and places it in a text area on the same page.
i was wondering if asp could be used to save the output to my server as a new file?
I hope we can upload only files with limited size through ASP scripts(<2MB). I need to write an ASP script that can serve up to 100MB of file uploading. I have written one script(with progress bar ;-)), as my hosting won't allow me any third party upload components. Is there any way we for ASP scripts to make larger file uploads?
View Replies View RelatedI need to everyday upload files to a server. The files to be uploaded will always be in the same folder and their names will be in the data base, so I know what files must be uploaded and where they are.
I usually upload files with a component in the same server. The user choose the files in a form (using the <input type="file"...> tag) and in the next page all the files are uploaded.
The problem this time is: the user doesnt want to everyday choose the files to be uploaded. He wants the process automatic.
I already know how to everyday load a page in the server, but I cant find a way to make that page upload the files by itself. I cant set the "value" attribute of a file input tag, it doesnt work.
I have written an web based client upload script. But i need to encrypt the files before the upload, and then a method of decrypting them at the server.
The files in question will all be audio files, all formats. I am new to asp/asp.net, so can anyone point me in the write direction in how do code the encryption. Is the 128 bit, the best method to use?
I just knew that uploading files using server.CreateObject("scripting.filesystemobject") does not allow you to upload files with size bigger than 10 megabytes. What is the better way to upload Huge files?
Other than creating a custom component or purchasing one, isn't there
any other way by which users can upload images/files from their local
machines/hard disks to a remote server? Doesn't ASP have any in-built
component to do so?
If that's indeed the case, can someone suggest any free components
(not trial ones) which can be used to upload images/files from users'
local machines/hard disks to a server?