This section details a selection of advanced features of the Microsoft Access driver.

SSL Configuration

Use SSL Configuration to adjust how driver handles TLS/SSL certificate negotiations. You can choose from various certificate formats; see the SSLServerCert property under "Connection String Options" for more information.

Firewall and Proxy

Configure the driver for compliance with Firewall and Proxy, including Windows proxies. You can also set up tunnel connections.

Linked Server

The driver can create a SQL Gateway that can execute linked server queries. In addition, if you are using Windows, you can set up ODBC remoting, which allows you to connect to the ODBC driver from remote machines.

SQL Gateway

The Connect from MySQL Workbench enables remote access to ODBC data sources as virtual SQL Servers or MySQL databases. In addition to brokering requests, the SQL Gateway allows for secure connections through firewalls. Connections are secured via TLS/SSL. SQL Gateway also supports SSH reverse tunneling, which is very useful for allowing cloud services to access on-premises data.

Logging

See Logging for an overview of configuration settings that can be used to refine CData logging. For basic logging, you only need to set two connection properties, but there are numerous features that support more refined logging, where you can select subsets of information to be logged using the LogModules connection property.