lyrDbConnections

This table is used by Aurea List Manager for ODBC connections.

Primary Key: ConnID

Field Name Description Version Added
ConnID

An auto-numbering field to provide a unique ID for this row. (int, NOT NULL)

Added in 8.8

ConnName

User-specified name of connection for display. (varchar(50), NOT NULL)

Added in 8.8

ConnStr

ODBC connection string (format is specific to driver being used) (varchar(1024), NOT NULL)

Added in 8.8

Site

What list or sites is this connection associated with. Association formatted like document association ("list: listname", "site: sitename", "all"). (varchar(66), NOT NULL)

Added in 8.8

SelectQuery

ODBC 'select' query. (text, NULL)

Added in 8.8