DISPLAY CONNECTIONS, LIST CONNECTIONS

These commands provide a list of named connections in a database. The name of the connection and the data source or connection string is listed.

Usage

DISPLAY | LIST CONNECTIONS
        [ TO PRINTER [ PROMPT ] |
          TO [ FILE ] cFileName [ ADDITIVE ] ]
        [ NOCONSOLE ]

The same information is available using ADBOBJECTS() and DBGetProp().

A database must be open and current before issuing the command.

Example

USE MyTestDBC
CREATE CONNECTION TestConnection ;
        DATASOURCE "MS Access 7.0 Databases"
DISPLAY CONNECTIONS

See Also

ADBObjects(), Create Connection, DBGetProp(), Display and List, Modify Connection