AnsweredAssumed Answered

Filemaker OBDC to SQL -> only number/date fields come over

Question asked by kyle on Oct 24, 2012
Latest reply on Oct 25, 2012 by philmodjunk

Title

Filemaker OBDC to SQL -> only number/date fields come over

Post

     Hi,

     I have a linked server connection in SQL to FileMaker Pro 11 Advanced by OBDC.

     For some reason when I select filemaker tables in SQL, only text and date values come over. The text colums will show NULL if nothing is entered for those fields in filemaker, however if there is something entered in filemaker, it will always just show spaces and no characters.  

     I have tried converting to varchar, varcharmax, char,text ,nvarchar and vchar and it always shows blank spaces.

      

     Does anyone have any idea why text fields aren't being brought over in SQL?

Outcomes