I am trying to set up FileMaker 10 Advanced as an ODBC data source for UPS Worldship. I have the DSN set and can map the fields in Worldship, but when I try the Keyed Import, I get the following dialog:
UPS Worldship Error: ODBC Error : State = S1000 Error = [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker] Parse error in SQL
This was originally set up using FMSA 10 on a Mac, but I get the same error in a test environment with FM 10 Adv local with Worldship. At first, I thought I might have offending field names (spaces, etc.) but that is not the case. I am attaching the import map from Worldship in case that helps.
I used the ODBC driver from the FMS disk and installed it as directed using the setup file (not the msi). Any suggestions would be useful.