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.
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 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....
I 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?
I 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?
I 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?
i 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
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:
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?
i 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.
I 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.
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 ....
uploading 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?
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.
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. /SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
I'm current working on a project which need to upload local data to live server database.
Meanings that, i'm current having a server in my local mechine. I need upload data from local database to live database which host at oversea company. But i really have no idea how to do this in asp.