Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

DELETE CONNECTION Command

Visual Studio .NET 2003

Deletes a named connection from the current database.

DELETE CONNECTION ConnectionName

Parameters

ConnectionName
Specifies the name of the named connection to delete from the current database.

Remarks

Deleting a named connection definition does not close any active connections.

DELETE CONNECTION requires exclusive use of the database. To open a database for exclusive use, include EXCLUSIVE in OPEN DATABASE.

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. DISPLAY CONNECTIONS is used to display the named connections in the database. The connection is then removed from the database with DELETE CONNECTION.

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

CREATE CONNECTION Myconn DATASOURCE "MyFoxSQLNT" USERID "sa"
DISPLAY CONNECTIONS    && Displays named connections in the database
DELETE CONNECTION Myconn  && Removes the connection just created

See Also

CREATE CONNECTION | MODIFY CONNECTION | RENAME CONNECTION

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.