AnsweredAssumed Answered

UPS Worldship ODBC Error

Question asked by dvalley on Aug 11, 2014
Latest reply on Aug 13, 2014 by dvalley

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.