Using the create connection command

To add a database for a non-ASE data server, use the create connection command with a connection profile specific to your non-ASE data server.

To add a database for an Adaptive Server data server, you use Sybase Central or rs_init, both of which prepare the database for replication. You can also use create connection for Adaptive Server data servers.

If you use create connection, you must prepare the database for replication yourself. Refer to “Steps in preparing databases for replication”.

Enter create connection at the Replication Server that is to manage the database. The syntax is:

create connection to data_server.database
	set error class [to] error_class
	set function string class [to] function_class
	set username [to] user
	[set password [to] passwd]
	using profile connection_profile[;version]
	[set database_param [to] 'value']
	[set security_param [to] {‘required’ | ‘not_required’}]
	[with {log transfer on, dsi_suspended}]
	[as active for logical_ds.logical_db |
	as standby for logical_ds.logical_db
	[use dump marker]
	[display_only]

You must use the with dsi_suspended clause, which starts the connection with the DSI suspended, when you create a connection to a database that will not be a replicate database.

The as active, as standby, and use dump marker clauses are used only when you create physical connections for a logical connection for a warm standby database. Only Adaptive Server databases may be used in warm standby applications.

If your system supports network-based security, use the set security_param command according to instructions in “Managing network-based security”.