The Advanced tab of the Connect dialog has the following components:
Connection name This field only appears when you open the Connect dialog from Interactive SQL. Type a name to identify the connection. If specified, the name appears in the title bar in Interactive SQL.
Enter connection parameters, one per line, in the form "name=value" Type any additional connection parameters in this field, entering one connection parameter per line. The following connection parameters log debugging information regarding connections:
DEBUG=YES LOG=connection.log
When you enter the connection parameters one per line, a semicolon is not required between the parameters.
TipYou can specify a network protocol as a CommLinks connection parameter on this tab, but the protocols available depend on the driver you select. For jConnect, the TCP/IP protocol is used automatically. |
Parameters set in this field take precedence over parameters set throughout the rest of this dialog. For example, if you enter the user ID DBA on the Identification tab, and set the connection parameter "uid=bsmith" in this field, a connection with the user ID bsmith is attempted.
For more information about connection parameters, see and .
Select a JDBC driver Lets you choose the type of driver you want to use for the connection. All requests and commands you make when working with the database go through this driver. You have the following choices:
iAnywhere JDBC driver Select this option to use the iAnywhere JDBC driver to connect using an ODBC driver. The iAnywhere JDBC driver is, in many cases, the preferred driver. It is the default driver for Interactive SQL and Sybase Central.
When you choose the iAnywhere JDBC driver, and you supply an ODBC data source, only the items on the Identification tab are used to establish a connection.
For more information about the iAnywhere JDBC driver, see and .
For more information about selecting a driver, see .
jConnect 5 Select this option to use a JDBC driver called jConnect for JDBC (a Sybase product). This driver is platform-independent and it supports all connection features, including the use of ODBC data sources.