Data Not Read Correctly with ODBC

[dcoryh192]

Hi,

New to Filemaker Pro and ODBC. I am trying to set up a parts database/library for my CAD software, Altium. Altium can read the data through ODBC. I have created a small test database to get started. I have the xDBC driver installed and I have set up a System DSN in the Windows Data Sources (ODBC) dialog. Altium is able to connect to my database, view the table, and read the column names.

When it reads the data in each cell, however, it just displays (MEMO) for each cell. In FileMaker, these cells are standard text cells. If I choose a number cell, date cell, time cell, etc., then these work perfectly and I can see them in Altium. Only the text fields seem to have a problem.

I found a site that mentioned that the memo field (or multi-line) is the default for FileMaker, and that "You have to take special actions to keep a field at one line" (http://www.tek-tips.com/viewthread.cfm?qid=1231827). Could this be the problem? Is Altium expecting a simple, one-line text field and Filemaker is giving it a multi-line field?

I have tried importing the database into an Excel table through ODBC, and that worked with no problems. But maybe excel can deal with the Memo fields and Altium can't?

Edited October 2, 2015 by dcoryh192
fixed hyperlink

[dcoryh192]

Found the solution here: https://community.filemaker.com/message/257595

The key is to set the maximum character limit to 255