A brief guide to connection strings for AnySQL Maestro (Updated)

The article contains a list of ODBC drivers and OLE DB providers AnySQL Maestro has been examined with. The corresponding connection strings are also included.

1. ODBC Drivers/OLE DB Providers

AnySQL Maestro works via ADO interface. So to work with a database, first of all you need to have the corresponding ODBC driver/OLE DB provider installed on your PC. The table below contains a list of drivers successfully tested with AnySQL Maestro as well as the links to the home page of each driver.

2. Connection Strings

To connect to a database with AnySQL Maestro, you need to enter a connection string at the
Create Database Profile window.
To get a connection string that is ready to use, specify parameters for the corresponding template. For example, if you want to connect
to the Sakila database at local MySQL server
as user Robin with password Red
using MySQL Connector/ODBC 5.1, your connection string could be as follows:

You can also provide additional parameters to specify how the driver should work. For example, if you want to
enable auto-reconnection functionality for the connection above, use the following connection string:

As the driver name for MySQL ODBC 3.51 Connector enter Driver={MySQL ODBC 3.51 Driver}, for MySQL ODBC 5.1 Connector - Driver={MySQL ODBC 5.1 Driver}, for MySQL ODBC 5.2 Unicode Connector - Driver={MySQL ODBC 5.2w Driver}, and for MySQL ODBC 5.2 Ansi Connector - Driver={MySQL ODBC 5.2a Driver}.
Port value is not necessary to be specified. By default it is equal to 3306. Here you can find the full list of the connection string parameters with explanation.

PostgreSQL ODBC Driver (psqlODBC)

The full distribution installs 2 drivers: PostgreSQL Unicode, a Unicode enabled driver that will work well with character from a huge range of languages, and PostgreSQL ANSI, an ANSI driver which is also able to handle some multibyte character sets such as EUC_JP, BIG5 and Shift-JIS.

Complete list of connection parameters is also available at SyBooks Online

3. Specialized tools

Though AnySQL Maestro includes all the basic tools for effective database management, we do also offer software products designed
especially for concrete DBMS. These products support advanced DBMS features such as stored procedures, triggers, grants and
work faster because of using direct connections instead of ODBC drivers.