Use sybase mode for maximum compatibility between different target databases.
sybase mode allows client applications to operate independently of the target they are accessing.
When sybase mode is in effect, the access service performs a limited amount of Transact-SQL® syntax transformation on the SQL text that it receives, including text found in these commands: language, cursor declare, dynamic prepare, and dynamic execute immediate.
In sybase mode, the access service transforms the SQL text it receives into syntax that the target DBMS supports. If the access service receives syntax it does not recognize, it passes the text to the DBMS for execution.
Because an application uses this mode for purposes of compatibility with all access services provided by Sybase, it should not issue SQL commands that are unique to any single target DBMS.
