MODIFY CONNECTION 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. MODIFY CONNECTION is used to displays the Connection Designer so you can modify the connection.

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

CREATE CONNECTION Myconn DATASOURCE "MyFoxSQLNT" USERID "sa"
MODIFY CONNECTION Myconn && Displays named connections in the database