FMP Export to MSSQL

[Kenny Rullo]

Hello everyone,

my name is Valerio and i'm at the very first experience with FMP.

I have a database with FMP to export to Microsoft SQL Server 2005 via ODBC. There are no problems until i need to export images from a "container" field from FMP to SQL Server.

Opened external datasource in FMP via odbc doesn't show me the right column to export. In SQL server i used either varbinary or image as field datatype but no luck.

Any help?

[bcooney]

Hi Valerio

Binary/blob filed types are not supported with ESS unfortunately. Maybe you can just store a path to the source?

hth,

Barbara

PS: See page 18 of the techbrief_ess_fm11_en.pdf

Edited October 25, 2010 by Guest

[Kenny Rullo]

Hello Barbara, thanks for your answer!!

I cannot make changes to FMP file, just access data via ODBC. This database has a "container" field where images are shown.

There is no way to "suck" these images, even importing from FMP via SQL Server SSIS?

Thanks again.

Hi Valerio

Binary/blob filed types are not supported with ESS unfortunately. Maybe you can just store a path to the source?

hth,

Barbara

PS: See page 18 of the techbrief_ess_fm11_en.pdf

[bcooney]

Oh, FM is the source. Didn't read closely enough.

See page 59 of this doc:

http://www.filemaker.com/support/product/docs/fmp/fm11_odbc_jdbc_guide_en.pdf

[Kenny Rullo]

Sorry for such late response, and thanks for the pointer. I'ill work on it!!

thanks again!