Hi,i am able to upload the files from client side and storing at the server.But my problem is how to save those files in the database(Msacess)?Any links or advises or appreciated..
Printable View
Hi,i am able to upload the files from client side and storing at the server.But my problem is how to save those files in the database(Msacess)?Any links or advises or appreciated..
I'm not sure if that is even possible but why don't you just store the link information to the file in the database.
Maybe this post won't help you much, but its "easily" possible
with an oracle sql server.
You can save files as binary large objects (blob) there.
But I don't know if access got something comparable.
access does have a comparable data type for storing images. its called :
OLE Object.
just for interest sake why would you want the image in the db. Access db's are notorious for corruption and your playing with fire storing an image in a db. You should store the image on disk and point to the directory in the database.
hth,
mcm
Doesn't it depend on what type of image you store in your database? I've heard of and seen bitmaps stored in databases without any problems.Quote:
Originally Posted by mcmcom
I agree with the assessment that access is no good though.
if you write binary it does not matter.