dbconnection update
The dbconnection update command modifies a connection between Spectrum Technology Platform and a database.
Usage
dbconnection update --n ConnectionName --d Driver --h Host --o Port --i Instance --u Username --p Password --l "property:value"| Required | Argument | Description |
|---|---|---|
| Yes | --n ConnectionName | Specifies the name for the connection you want to modify. To view a list of connections, use the dbconnection list command. |
| Yes | --d Driver | Specifies the driver for the type of database you want to connect to. To view a list of database drivers available on your server, use the dbdriver list command. |
| Yes | --h Host | Specifies the host name or IP address of the database server. |
| No | --o Port | Specifies the network port to use for communication with the database server. |
| No | --i Instance | Specifies the database instance to connect to. |
| No | --u Username | The user name to use to connect to the database, if required. |
| No | --p Password | The password to use to connect to the database, if required. |
| No | --l "property:value" | Specifies a comma-separated list of connection property and value pairs for the
driver. To view the list of valid properties for a driver, open Spectrum Management Console, go to , then click the Drivers tab. Select the driver you
want then click the Edit button  to view its connection
properties. |
Example
This example modifies a database connection named NorthernRegionCustomers. It changes the driver to MSSQLServer2, changes the host to MyServer2, and changes the instance to MyInstance2.
dbconnection update --n NorthernRegionCustomers --d MSSQLServer2 --h MyServer2 --i MyInstance2