[AccessD] Opening Files from BLOB in SQL Server 2012

[Jurgen Welz]

I'm attempting to access files of various types stored by an accounting application.  I've found an old knowledge base article applicable to Access versions 1 though 97:  https://support.microsoft.com/en-us/kb/103257   

I'm using an ODBC connection because that's what we have been using universally and it remains solid.  It works to read the file data from the database column because the binary data I'm pulling matches the file size of the item stored.  The problem I'm having is when I write the file to disk, it is showing up with exactly 1/2 the size.  It is like I'm writing a 32 bit file into a 16 bit file system.  Attempts to open the files written to the file system result in a report that the file is damaged or corrupt.

If, for example, I've got a file made of 10 chunks 100 bytes long plus 30 bytes, as the file is written and the first 30 bytes is added to the file, it reports as size of 15 bytes and an additional 50 bytes as each additional chunk is appended to the file.

Does anyone have a suggestion as to how I might store and or just open these files.  File types are Office documents, various image types, pdfs, msg or any number of other file types for which we generally have applications. We are running Windows Server 2012 R2 64 bit and Office 32 bit.

Jurgen Welz
Edmonton, AB