dbconnection update

The dbconnection update command modifies a connection between Spectrum Technology Platform and a database.


dbconnection update --n ConnectionName --d Driver --h Host --o Port --i Instance --u Username --p Password --l "property:value"
Yes--n ConnectionNameSpecifies the name for the connection you want to modify. To view a list of connections, use the dbconnection list command.
Yes--d DriverSpecifies 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 HostSpecifies the host name or IP address of the database server.
No--o PortSpecifies the network port to use for communication with the database server.
No--i InstanceSpecifies the database instance to connect to.
No--u UsernameThe user name to use to connect to the database, if required.
No--p PasswordThe 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 Resources > Data Sources, then click the Drivers tab. Select the driver you want then click the Edit button to view its connection properties.


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