/features/connectionstrings
CONNECTION STRINGS
To manage connection strings in Enzo Manager, select the Configuration->Manage Connection Strings menu. A connection string can point to virtually any database system, including SQL Server, MySQL, Oracle and virtually any ODBC system. Depending on the database you are trying to configure you may need to install the necessary ODBC driver.
When the connection string points to an Enzo Server, the IsEnzo flag will be set to true. This is referred to as a loopback connection.
Use this screen to create, update and delete connection strings. You can also try to connect to a database from this screen.
Access to connection strings can be limited to specific Enzo logins. If no logins are specified, any Enzo login can use the connection string.
When creating a new connection string you can select a SQL Server connection or a generic ODBC connection string.
For some adapters the default catalog can be an important setting; for SQL Server the default catalog can also be set as a property of the database account. If this connection string is a loopback connection to Enzo, the default database is always assumed to be bsc, and as a result it is optional.
Leaving the Login/Password blank implies that the connection will use whatever Windows Account the Enzo Server service is running under.
DRIVER={MySQL ODBC 5.3 UNICODE Driver};Server=YOUR_SERVER; Database=YOUR_DATABASE; User=YOUR_UID;Password=YOUR_PWD;Option=3;