Data Source Connection Settings

If you elect to use the Windows ODBC connection manager, you will need to consult the information below, or your connection will be problematic. In general you have to specify a data source name (DSN) to uniquely identify the data source, the server, the database, the database user, and the user's password. There may be other settings that need to be changed. The following is a guide to those changes, though please note that different versions of the ODBC drivers may organise the DSN setup form differently.

Firebird

The following must changed from the default:

• Data Source Name (DSN). This is the descriptive name to identify the data source to anyone trying to use it.
• Database: This should be in the form <servername>:<database pathname> (eg mywinserver:c:\AMDatabase\userinfo.fdb, mylinuxserver:/usr/AM/userinfo.fdb). <servername>: can be left out if the database server is on the same machine.
• Database Account: Unless you have set up users on Firebird this should be SYSDBA.
• Password: Unless you have set up users on Firebird this should be masterkey.
• Check the Sensitive Identifier option.
• If you use Access Manager to create the database file you should set the character set to WIN1252.

MySQL

The following must changed from the default:

• Data Source Name. This is the descriptive name to identify the data source to anyone trying to use it.
• Server: The URL of the database server.
• User: The name of a user set up on the server.
• Password: The user's password.
• Database: The name of the database.
• Return Matching Rows: This must be checked. It can be found under the Advanced tab.

PostgreSQL

The following must changed from the default:

• Data Source: This is the descriptive name to identify the data source to anyone trying to use it.
• Database: The name of the database.
• Server: The URL of the database server.
• User: The name of a user set up on the server.
• Password: The user's password.
• Bool as Char: This must be unchecked. It can be found by clicking on the data source options button (Page 1).
• True is -1: This must be checked. It can be found by clicking on the data source options button (Page 2).