dreed

Importing binary data from SQL Server

Discussion created by dreed on Oct 24, 2012
Latest reply on Oct 26, 2012 by LSNOVER

I discovered something today which I've not seen discussed before. Using the Open menu command and choosing an ODBC data source, I was able to import SQL server data into a filemaker table and was able to bring in varbinary(max) data. Filemaker put this data into a container field and all the file icons are named Untitled.dat. If I export field contents, naming the file according to the filename data stored in RQST_TREE_NAME, the attached files are all readable from their native applications.

 

I was always under the impression that getting at binary data in SQL databases was not possible via ODBC, and that additional code was required to pull out that data and get it into containers. Has anyone else ever seen/done this?

 

ss.jpg

Outcomes