All geek questions in one place

Access field MS Access, SQL Server

I spent almost 2 days trying to figure it out. We have had an Access (adp) project since 2000 that stores images on SQL Server 2008. I tried to connect directly to SQL Server and open the TIFF files, but it does not work. Also tried to copy / paste the contents of the image field into a file, rename it to TIFF and try to open it, but it also does not work. The problem with the content in the image field is that it does not have the right size. It is only 15-20 KB, but the files in this place should be about 3 MB. It works fine if I return the same data back to the ACCESS project application.

I tried TiffLib.net and a few other things.

So, does anyone have any ideas on how to transfer these image fields to SQL?

thanks

+4
source share
1 answer

Well, the image data type stores a binary version of your image. The conversion process is now explained in the links below. You will need to use the library to convert the byte array to an image object.

http://www.akadia.com/services/dotnet_load_blob.html

http://www.dreamincode.net/forums/topic/103960-save-and-retrieve-images-with-sql-server/

Hope this helps.

+1
source

Source: https://habr.com/ru/post/1396944/

More articles:


All Articles