SQL transformation modes affect the way the access service modifies SQL statements that are written for one database but are processed against another. Although the transformation mode primarily affects the way in which the access service treats incoming SQL statements, it also affects these functional areas:
Transaction
Datatype handling
set statements
RSPs
ASE/CIS interoperability
ODBC driver interoperability
When you configure the access service with a specific transformation mode, that mode is effective for all client connections unless you use a set statement to alter it for a specific connection.
To make dialects appear as common SQL, the access service supports these standard transformation modes:
passthrough
sybase
