SQL Anywhere Studio Help
Connect Dialog Help
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 Connection parameters and How connection parameters work.
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. It is the default driver when connecting from the MobiLink Sybase Central plug in.
When you choose the iAnywhere JDBC driver, you must supply an ODBC data source, and only the items on the Identification tab are used to establish a connection.
For more information about the iAnywhere JDBC driver, see Using the iAnywhere JDBC driver and Choosing a JDBC driver.
For more information about selecting a driver, see Specifying a driver for your connection.
jConnect 5 Select this option to use a JDBC driver called jConnect for JDBC (a Sybase product). This driver is platform-independent and offers the best performance. It supports all connection features, including the use of ODBC data sources. It is the recommended driver and is used by default unless you are connecting from the MobiLink Sybase Central plug-in.
Troubleshooting server startup
Troubleshooting network communications