You are here: ListManager Programmer's Guide > ListManager Tables > Configuration > lyrDbConnections

lyrDbConnections

 

This table is used by ListManager 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