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

RENAME CONNECTION Command

Visual Studio .NET 2003

Renames a named connection in the current database.

RENAME CONNECTION ConnectionName1 TO ConnectionName2

Parameters

ConnectionName1
Specifies the name of the connection to be renamed.
ConnectionName2
Specifies the new name of the connection.

Remarks

The database containing the named connection must be opened exclusively and must be current before the connection can be renamed. 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 Myconn1 is created. DISPLAY CONNECTIONS is used to display the named connections in the database.

RENAME CONNECTION is then used to change the newly created connection name to Myconn2. DISPLAY CONNECTIONS is used again to display the connection with its new name. The newly renamed connection is then removed from the database with DELETE CONNECTION.

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
CREATE CONNECTION Myconn1 DATASOURCE "MyFoxSQLNT" USERID "sa"

CLEAR
DISPLAY CONNECTIONS  && Displays named connections in the database
RENAME CONNECTION Myconn1 TO Myconn2
DISPLAY CONNECTIONS  && Displays connection with new name

DELETE CONNECTION Myconn2  && Removes the connection just renamed

See Also

DELETE CONNECTION | DBGETPROP( ) | DISPLAY CONNECTIONS | LIST CONNECTIONS | MODIFY CONNECTION | OPEN DATABASE

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