SQLTransformation

Specifies the mode the access service uses for SQL transformation.

Syntax

SQLTransformation=[passthrough |sybase | tsql0 | tsql1 | tsql2]

Default

passthrough

Values

  • passthrough sends all SQL statements to the database system as received, without transformation. A client application uses passthrough mode to gain direct access to DBMS capabilities.

  • sybase performs SQL transformation of selected statements. It also allows the use of multipart table names with the view command in SQL statements.

Parent topic: Target Interaction Properties