LIST CONNECTIONS Command Example

The following example assumes an ODBC data source called MyFoxSQLNT is available, and the user ID for the data source is "sa." The testdata database is opened, and a connection named Myconn is created. LIST CONNECTIONS is used to list the named connections in the database.

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'data\testdata')

CREATE CONNECTION Myconn DATASOURCE "MyFoxSQLNT" USERID "sa"
CLEAR
LIST CONNECTIONS     && Lists named connections in the database