Connection Options Database Type / WinSQL Plug-in

This connection option specifies the type of database to which you are connecting, and it also specifies a database plug-in. The names displayed in this list include the database plug-ins identified by WinSQL Professional when it is started. The option to select database type is only available in WinSQL Professional.

For more information about plug-ins, see “Database-Specific Plug-Ins” later in this document.

Important note: If the database to which you are trying to connect is not displayed in the list, it does not mean you cannot connect to that database with WinSQL Professional. It means that WinSQL Professional will not be able to query specific database features, such as triggers and SQL scripts for views and stored procedures.Auto commit transactions

When this option is checked, all transactions are automatically committed. Certain databases, such as Oracle, do not allow explicit transactions. Therefore, it may be useful to turn off this option, which will allow you to manually COMMIT and ROLLBACK any transaction.

When this option is turned off, a red indicator appears on the status bar. This indicator is a reminder to COMMIT or ROLLBACK before closing the connection.

Enable catalog caching

Selection this option at connection allows WinSQL to automatically create a cached version of your database catalog on your local machine. Caching your database catalog reduces the amount of time it takes to fetch metadata information from the back-end database, which greatly increases access time to your data.

When caching is enabled, WinSQL stores the contents of the Catalog Details window to a local file. The next time you connect to the same database, WinSQL loads the catalog information from this local file rather than sending queries to the database.

For more information, see the “Database Catalog Fetching” topic later in this document.

Load catalog after connection

Selecting this option allows WinSQL to fetch the database catalog immediately after establishing connection.