0 Replies Latest reply on May 15, 2013 9:18 AM by DAvery

    ODBC from Windows won't return Text

    DAvery

      Title

      ODBC from Windows won't return Text

      Post

           I'm trying to query a filemaker instance via ODBC from Windows and the queries will ONLY return numeric/date data, if a Text column is included in the query the field comes back blank.

           I've verified that both my source (Filemaker) and destination (MS Access) tables/columns are all text of the same length and I've also followed this ...

           http://help.filemaker.com/app/answers/detail/a_id/7843/~/no-data-returned-from-filemaker-text-fields-via-odbc-queries-on-windows

           ... to make sure the max length is set and the data still won't come through.  I've also tried wrapping the text field in a substring() function to limit the number of characters coming back and the text data just won't come through.  There are no SQL errors that I can tell.

           Is there some trick to getting Text data to come back through via ODBC?

           Thanks!!