Performing Queries in Passthrough Mode in SQL Server Databases

Queries can be performed in passthrough mode through the SQL Server driver. Joins made between two SQL Server tables stored in the same SQL Server database are performed on the Windows SQL Server automatically. This enhancement increases the speed of join queries of this type, especially those that use a Where clause in the SQL statement. If a function is used within the query that does not exist in the SQL Server database, CONNX processes the query internally.


Important: SQL functions not natively supported by SQL Server cannot be used with SQL passthrough.