Filemaker OBDC to SQL -> only number/date fields come over
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?