Persits Upload ( ASP Upload ) AND Database Integration
I need some help with aspupload and a database. I have used the same script before and it worked fine, but now it wont upload. Code:
View RepliesI need some help with aspupload and a database. I have used the same script before and it worked fine, but now it wont upload. Code:
View RepliesI keep getting the following error message when attempting to run the below script.
Persits.Upload.1 (0x800A001)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
line 42.
line 42 is "File.ToDatabase Connect, SQL"
Code:
I just moved a site to a new host and now when I try to upload a picture for a real estate site I get:
D:hshomealcadminarizonarenttoown.comadminPIC_Upload.asp
Persits.Upload.1 error '800a0028'
This feature has been disabled by system administrator. Use File.SaveAsVirtual instead.
/admin/PIC_Upload.asp, line 25
Its something to do with this but I don't know how to correct: http://www.aspupload.com/object_upload.html#SaveVirtual
If I paste part of the code to my script could someone help me out if it is a simple fix? ....
I have put together a form where i can browse for an image and then upload this to my web site.
Then i would like to take the location of the new uploaded image and add it to my database.
This is where i am having trouble! i cannot seem to put the location(s) of the images into an array.....
how can i upload all the files of a folder which is selected by the user using persits.upload
View Replies View RelatedI have an ASP script which is used to upload files with Persits.Upload.1 object. But I can't get the values from mutliple checkboxes in the form like normally.
<form method="post" ENCTYPE="multipart/form-data"....>
<input type="checkbox" name="language" value="English">English
<input type="checkbox" name="language" value="Spanish">Spanish
<input type="checkbox" name="language" value="Chinese">Chinese ....
I'm putting a website on a different server to what I normally use and I've had to adjust from Persits.Upload to Persits.Jpeg. I'm not sure what I'm doing here? My code works fine on the old server. Code:
View Replies View RelatedI am using a form to upload images with Persits.Upload object. Now my problem is I cant use multiple checkboxes in the form.
In general forms I can use Form("checkboxName").Count to get the number of checkboxes selected and use Form("checkboxName")(i) to retrieve the value of each check box.
This doesnt work with Upload.Form
We face problems uploading excel (with macros) documents using HTML
File Upload.
The file contents are corrupted while viewing the same. However, we
are able to upload excel (w/o. macros) documents successfully. Is
there anything we have to take care of, while handling uploads of
excel documents with macros?
I have been using pure asp upload for uploading pictures and files fo rome time now.
I have a question about it thou - Is there any chance that the pure asp upload can upload a file to a directory and then copy it to a backup directory?
If anyone ever come accross this issue please let me know how u resolve it.
Im doing a basic update to a table using asp:Code:
rs.AddNew
rs("qsID") = request.Form("qsID")
rs("qsType") = request.Form("qsType")
rs("qsTitle") = request.Form("qsTitle")
rs("qsRevision") = request.Form("qsRevision")
rs("qsUpdated") = date()
rs("qsFileType") = request.Form("qsFileType")
rs.update
The only difference is this time I am inserting the primary key rather than using an auto number. the following error message appears:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F)
[Microsoft][ODBC Microsoft Access Driver]Error in row
I went onto the microsoft kb and the said that it was something to do with the PK. Has anyone encountered this problem before
I am trying to develop a web site in which the user can add records to the database from an admininstration section of the site. I'm using an access database (there will only be about 60 or so records at any time).
I can create a page that makes the user fill out a form to add a record like the sample below...but I'd also like a place where the user can just upload a CSV file directly into the database. I don't know a lot about ASP, but I'm planning on doing it in DMX.
I want 2 upload a image and some text to the sql server database. and in anothere page i will retrieve all the fields . so can anybody help me.i am giving u the html source....
View Replies View RelatedI have this page/form in asp that connects to my ms access database that I would like to have it either a) upload a picture or b) display the picture if one's already uploaded. I'm looking for direction on this and have no idea where to begin or even what's what. Can I upload a picture into the database?
View Replies View RelatedHow can i upload a file from a asp form to a database?
View Replies View RelatedI have this page/form in asp that connects to my ms access database that I would like to have it either a) upload a picture or b) display the picture if one's already uploaded. I'm looking for direction on this and have no idea where to begin or even what's what. Can I upload a picture into the database?
View Replies View RelatedI am developing a forum style website using ASP and I need to have a file attachment function when people post notices. Does anyone know how to do this? So far has only helped with showing me how to upload files to a server but I need to upload them into the access database to retrieve it when needed. Is this possible?
View Replies View Relatedi am working with asp form where the user can upload files to a folder or to the database, uploading files in folder in working, but the database one is not working it give me the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/test/uploadexmple.asp, line 48
and here is my code:
I want to upload either image or word document into either access or SQL server database so far I am doing some small testings and what I can do is upload the file from first page and display at the next page with (both image or word are working fine).
however, I cann't insert them into the database, Plus, what type should I use in access database? Code:
Code:
Dim sConnection
sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=" "; UID="";PASSWORD=""; OPTION=3"
using this code(connection), how can i upload the mySQL Database? you see, i can't install mySQL online..
I am trying to add an option on a form to upload an image to an access database, but I can't seem to get it working. I am able to upload regular text fields to the database with no problem, but got stuck at uploading image.
I don't want to upload the name of image, just the actual jpeg/gif image. I've searched many websites and forums, but codes aren't working. Can someone help me with this? Here are the codes:
i would like to ask isit can upload image into database(ms access 2003) from asp. if can, how the code can be written? then if after upload image into database. how we can retrieve it from database into asp page for viewing?
View Replies View Relatedi have now found codes to get the images from the the access database, but i havnet found the code for uploading to an access database. can anyone please help me? i just need the code sample to upload images to an access database.
View Replies View RelatedI want to upload a file then add a record in a database using info from the uploaded file. I can't figure this out. If anyone has something working that isn't this please let me know. I would rather have this working as I don't want to recode the whole thing.
First the upload doesn't work. The MBRequest(file1).Save isn't supported in this manner. I know you can use .save to upload a file.
Second You'll see that MBRequest is called to form a filename. The filename is called in another page to form a link to the file......
I have just uploaded the files to a where they will reside and am now getting the following error
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file '
syd9004papc$InetpubwwwrootGMS_Statsgms_st ats.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
I have checked IIS on the server where this DB resides and have allowed as much rights as I can ... Has anyone seen this error before? I realise it must have something to do with security but I don't know if it's IIS or DB related?
I'm having this problem with uploading a file and updating the database at the same time the file will get uploaded but nothing will get updated into the database. Can anyone help me out. The third page is where everything is going wrong but i put all my pages in so you can see whats going on.
Here is my first page .....
I have attached the file upoading system in this thread.
It is working fine with MS Access Database but when i change the database to MS Sql Server then its upload not works i think its security problem, or the problem is that when i import the MS Access table into MS SQL server it change the field datatype from oleobject to image.
I am using ASP Upload to upload an image to a website. I have other form fields in the form that are used to obtain data and are inserted into an access database. This occurs on the same page as the page that upload the image. Everything works fine except it inserts each record twice into the database. Anyone have an idea what causes this or what I can do to make it only insert once. I am useing the progress bar and don't know if that has anything to do with it. Here is my code.
Set rsPhoto = Server.CreateObject("ADODB.RecordSet")
Set Upload = Server.CreateObject("Persits.Upload.1")
Upload.ProgressID = Request.QueryString("PID")
Upload.SetMaxSize 500000, True
Upload.Save ....
I am trying to write a page that lets the user upload any file to a server and this also stores the name of the uploaded file in to the database.
So far I'm not having much luck. I am a novice with ASP and really could do with some help.
I have been trying to use ASP Upload but it is confusing me as how to modify the script to allow me to insert the name of the File in to the database.
Here is my form page (you will notice this checks to see if we are uploading/editing or deleting). Code:
I would like some one to help me in how to upload a file at aprticular kind of a file in the server at save it in a database in a feild using an asp.
View Replies View Relateduploading images directly to a field (of type OLE Object) in the table in access database and also how would I get them displayed in the products page.I need to know this for an online catalogue management site and have done similar things a lot of times using Persits.
Upload where I upload the images to a location in the site and refer the location and file name in the database. But, unfortunately, this server doesnt support this object and I need to find a way as explained above.
I have two forms, the first of which has a dropdown with which the user specifes how many banner ads he wishes to upload for a client. So say he enters the client info and wants to upload 5 banners. The form passes to another page which uses a loop to output form fields. Each form field name is something like name="msg<%= count%>" or name="url<%=count%>".
In the 3rd-Party script I am using I then have this script ....
I want to be able to upload a image to a directory called 'images' on my server and also save the file name in a database. is there anything out there that does this without a COM?
View Replies View Related