ODBC problem with incompatible data type

[lonesomejubilee]

Hello,

Please forgive me, this is my first attempt to use FMP as the source for ODBC data....

I am using FileMaker Server Advanced 9 and am trying to connect a Employee ID Badging machine / software to my FMP database. I think the software is called ID Works Automation or something. Anyways, in the application I am try to connect the fields and it always gives me a message: "Incompatible Data Type" . The only data type options for ID Works is text, photo, date, and signature. I am trying to connect something as simple as name and it gives me the error. Dates connect, but not simple text fields.... it shouldn't matter if it's a number because the field is still a text field.

Has anyone come across this and if so, how or what can I do? If I cant get this badging machine and software to talk to my FMP solution, i'm in real trouble!

Thanks.

Vandy