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

Lyris, Inc.

6401 Hollis Street., # 125

Emeryville, CA 94608

Customer Support:

1-888-LYRIS-CS (1-888-597-4727)

or

1-571-730-5259

Hours:

Monday through Friday

6:00 a.m.--6:00 p.m. PST