Why Am I Receiving An ODBC 37000 Syntax Error With Shipping Manifest?
When using the Real Time Manifest interface special to import information from a shipping software i.e. UPS Worldship or FedEx Shipping Manager, the process interacts with export tables defined in the shipping software and writes to a text file that will be used for importing into Profitmaker.
It is possible when processing a package you may encounter a Windows message, 'ODBC syntax error 37000'.
If you receive this error, the shipping software is using an odbc text driver created on the computer that is processing the shipping package. If the defined database directory, which is the manifest path in the ProfitMaker system found in company information, in the odbc text driver is not receognized as being mapped to the computer, then the user will reveive the syntax error. The manifest path will need to be mapped on this computer.