The type of connectivity driver used on the primary database connection.
One of the following values is set automatically when the Replication Agent instance is created.
MSSQLJDBC – Replication Agent uses the Microsoft SQL Server JDBC driver to connect to the primary Microsoft SQL Server database.
ORAJDBC – Replication Agent uses the Oracle JDBC driver to connect to the primary Oracle database.
UDBODBC – Replication Agent uses the DB2 Universal Database ODBC driver to connect to the primary database in DB2 Universal Database.
The value of the pds_connection_type parameter is set automatically at the time a Replication Agent instance is created. The specific value depends on the type of Replication Agent instance created.
Sybase recommends that you do not change
the default value of the pds_connection_type parameter.
The value of the pds_connection_type parameter determines which of several other Replication Agent configuration parameters related to the primary database connection must also have values specified.
MSSQLDBC requires corresponding values for the following parameters:
pds_server_name
pds_port_number
pds_database_name
UDBODBC requires corresponding values for the following parameters:
pds_database_name
pds_datasource_name
ORAJDBC requires corresponding values for the following parameters:
pds_host_name
pds_port_number
pds_database_name
If using the tnsnames.ora file the following parameters are required:
pds_tns_filename
pds_tns_connection
The value of the pds_connection_type parameter is automatically when a Replication Agent instance is created.
