CREATE CONNECTION Command

Example   See Also

Creates a named connection and stores it in the current database.

Syntax

CREATE CONNECTION [ConnectionName | ?]
  [DATASOURCE cDataSourceName]
  [USERID cUserID] [PASSWORD cPassWord]
  [DATABASE cDatabaseName]
  | CONNSTRING cConnectionString]

Arguments

ConnectionName

Specifies the name of the connection to create.

?

Displays the Connection Designer from which you can create and save a connection.

DATASOURCE cDataSourceName

Specifies the name of the ODBC data source for the connection.

USERID cUserID

Specifies your user identification for the ODBC data source.

PASSWORD cPassWord

Specifies your password for the ODBC data source.

DATABASE cDatabaseName

Specifies a database on the server to which the connection is made.

CONNSTRING cConnectionString

Specifies a connection string for the ODBC data source. The connection string can be used instead of explicitly including the ODBC data source, the user identification, and the password.

Remarks

If you omit the optional arguments, the Connection Designer appears, allowing you to interactively create a connection.