Filemaker can't see MSSQL blob fields

[Gary Hoffman]

I've successfully connected my FMS 10 to a MS SQL server via ODBC and my Filemaker database can set up an MS SQL table as an external data source. When I connect to a table that has blob fields, Filemaker doesn't see them, only the text fields.

I had hoped to import the blob field contents (documents in Word or PDF format) into the Filemaker's container field, but if I can't see 'em, I can't gets 'em.

I also use Aqua Data Studio to browse the MS SQL server via JDBC. It sees the blob fields and when I do a select on blob data, ADS converts it to binhex code. ADS is obviously a text-data tool.

Has anyone done such a thing (import binary data from MS SQL to Filemaker container field)?

Thanks,

Gary

[bcooney]

See Link

[Gary Hoffman]

Ok, so they are not supported through ODBC. I guess I'll try importing via a JDBC plug-in.

Thanks for the reference.