create connection

Syntax

create connection connection_name 
set type [{to|=}] ASE | ASE_CLUSTER | RSSD
and set agent [{to|=}]agent_name 
and set host  [{to|=}] host 
and set port [{to|=}] port
and set database [{to|=}] database_name
and set user [{to|=}] user
[and set password [{to|=}] password]
[and set desc [{to|=}] description]
[with node set host [{to|=}] host and set port [{to|=}] port
[and node set host [{to|=}] host 
and set port [{to|=}] port]…]
[with properties set property_name [{to|=}] property_value
[and set property_name [{to|=}] property_value ]…]

Parameters

• connection_name – the name of the connection to be created.
• type – (Optional) the connection type supported by Replication Server Data Assurance Option: Adaptive Server Enterprise (ASE), ASE_CLUSTER, and Replication Server System Database (RSSD). If type is not provided, but the node parameter is provided; the value defaults to ASE_CLUSTER; otherwise, it will default to ASE.

  You cannot set the host name and port number for an ASE_CLUSTER connection; you must set these values inside a node definition. agent_name is invalid, if connection type is Replication Server System Database (RSSD). An RSSD connection cannot define an agent.

• agent_name – the name of the agent that establishes the connection to the database.
• database_name – the name of the target database.
• host – the host name of the machine on which the target database is installed.
• port – the port number of the machine on which the target database is installed.
• user – the login name of the Replication Server Data Assurance Option administrator who can access the target database. The user must have permission to execute select, update, insert, and delete queries.
• password – (Optional) the password for the administrator user login name.
  Note: If you have created an Adaptive Server instance with your system administrator (sa) login and set the password to null, you must also state a null password in DA server, either by not setting a password at all, or setting a password to "blank".
• description – (Optional) description of the agent. Use double quotes if you are using a reserved word or blank spaces.
• property_name – the connection properties for the Sybase JDBC driver, jConnect for JDBC, which establishes the connection to the database.

  See jConnect for JDBC 7.0 > jConnect for JDBC 7.0 Programmers Reference > Programming Information > Establishing a Connection > Connection Properties.

• property_value – the value of the property to be set.

Examples

• Example 1 – creates an Adaptive Server connection named “MyConnPDB”:

  create connection MyConnPDB
  set type=ASE
  and set agent=pdbAgt,
  and set database=mypdb
  and set host=myhost
  and set port=1111
  and set user=myuser
  and set password=mypwd
  go

  The returned result is:

  Connection “MyConnPDB” was created successfully

• Example 2 – creates an RSSD connection:

  create connection MyRSSDConn
  set type=RSSD
  and set host=rshost
  and set database=RSSD_database_name  
  and set port=2222
  and set user=rsuser
  and set password=rspwd
  go

  The returned result:

  Connection “MyRSSDConn” was created successfully.

• Example 3 – creates an Adaptive Server connection with properties:

  create connection MyConnPDB
  set type=ASE
  and set agent=pdbAgt,
  and set database=mypdb
  and set host=myhost
  and set port=1111
  and set user=myuser
  and set password=mypwd
  with properties
  set REQUEST_KERBEROS_SESSION=true  
  and set SERVICE_PRINCIPAL_NAME=myserver
  go

  The returned result:

  Connection “MyConnPDB” was created successfully.