EDBE engine error (SQL run-time error using Informix database)

Problem statement : When using SQL builder running a query which
accesses Paradox data files on the client and Informix data files on the
server, the query runs perfectly. However, the compiled .EXE gives the
following error : "Raised exception class EDBE engine error with message
: General SQL error [Intersolv][ODBC Informix driver][Informix]. A
syntax error has occured. Any ideas on what the problem may be will be
highly appreciated !