How do I set tables to use ODBC with GMS Communication Server

Question

What are the table formats I can use with GMS Communication Server in conjunction with either Access or SQL Server.

Answer

ACCESS
No need to create a DSN but a predefined system DSN can be used and ODBCDataSourceName should be set to this. If no DSN exists we will create one and any name specified in ODBCDataSourceName will be used and the created DSN will be associated with the file given in MemberFile.

1. no initial db or existing db with no table
   Optionally specify a table name in variable ODBCTableName.

2. existing db, existing table
   Must specify the table name in variable ODBCTableName.

SQL SERVER
Need to specify a system DSN which has been set up to point to their SQL server. ODBCDataSourceName should be set to this name.

1. no initial db
   May optionally specify a database name in the DSN and may optionally specify a table name in variable ODBCTableName.

2. existing db, no table
   Must specify database name in DSN, and may optionally specify a table name in variable ODBCTableName.

3. existing db, existing table
   Must specify database name in DSN, and must specify the table name in variable ODBCTableName.

Table Format
If an existing table is to be used then the following format options are available:

1. a one column (any name) table containing email addresses. This will be converted to the 4 column format automatically.
2. a four column table with column 1 named UserID, column 2 named UserName, column 3 named Domain and column 4 named Type.
3. a >4 column table with column 1 named UserID, column 2 named UserName, column 3 named Domain and column 4 named Type. Any other columns will be interpreted as variables with RequiredFields and OptionalFields set up to map onto these columns.

The Type field can be set up to specify values for things such as ACK, DIGEST and SHOW, settings for this are given in the GMS Mail Reference Guide.

Keywords:ODBC, GLCommunicator, SQL, Access, GLCommunicator, GLCom, GLList, database