How to save an image from SQL Server to MS Access .mdb

I have a SQL Server database with a table that has a column that stores an image. I have another database and I would like to store the image from the SQL Server database into it. It's type is MS Access 2000 format .mdb.

The problem is I get back the content of the column and I put them in an array of bytes as follows:

 Dim arrByte() As Byte = CType(dtAll.Rows(0)("DailyProgram_Image"), Byte())

It sends me back the data of the image as byte type. When I try to save this into the access DB it give me an error because of type mismatch.

Answers


Codeproject has an article about uploading and downloading BLOBs to Access here http://www.codeproject.com/KB/database/AccessBlob.aspx


Need Your Help

What is alternative to use after jQuery 1.9 removed .toggle(function,function)?

jquery css animation toggle

Hi i'm trying to create something that will alternate shrinking and growing on every click, but i'm using jQuery 1.9 for my website. the .toggle(function,function) function was removed from jQuery ...

AChartEngine - Line width of axes

android width line axis achartengine

Is there a possibility to set the line width of the x-/y-axis in AChartEngine?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.