Add Database Manager - ODBC

Pro Cloud Server connections to MySQL, Oracle and PostgreSQL based databases require the use of ODBC DSNs, which need to be defined in the Windows 'ODBC Data Source Administrator (32-bit)' screen. If you are running the Configuration Client on the same machine as the server you can:

1. Click on the button to open the 'Data Link Properties' dialog to build the connection string.
2. Select the provider 'Microsoft OLE DB Provider for ODBC Drivers' and click on the Next >> button.
3. Select the pre-defined System DSN from the 'Use data source name' field.
4. Fill in the user name and password and select the 'Allow saving password' checkbox.

Notes:

• All ODBC DSNs should be defined as SYSTEM DSNs, because the Pro Cloud Server runs as a Windows Service and User DSNs might not be available to the Pro Cloud Server
• The step for filling in the user name and password might not be required if the user name and password have been saved with the ODBC DSN
• The ODBC Data Sources button displays the Windows 'ODBC Data Source Administrator' dialog, which you can use to set up a new ODBC system data source to be listed on the 'Data Link Properties' dialog (if you are running the administration client on the same machine as the server); it is particularly helpful because it shows the 32-bit ODBC data sources.