Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Remote Server property sheet: General tab

The General tab of the Remote Server property sheet has the following components:

Name    Shows the name of the remote server.

Type    Shows the type of object.

Read-only    Shows whether or not the remote server is read-only.

Server type    Shows the class or software platform of the database server. You can choose a different software platform from the dropdown list to change the server type.

The server type that you choose restricts the types of connection you can choose from. For example, if you choose Generic Server from the Server Type dropdown list, you can only connect using ODBC.

Connection type    Lets you choose between the ODBC and JDBC connection protocols.

• Open database connectivity (ODBC)    Select this option to use the ODBC connection protocol. You can use ODBC with any of the servers listed in the Server Type dropdown list.

• Java database connectivity (JDBC)    Select this option to use the JDBC connection protocol. You can use JDBC with the following server types: Sybase SQL Anywhere and Sybase Adaptive Server Enterprise. If your database is not Java-enabled, the Java Database Connectivity (JDBC) option is not enabled.

  For more information about ODBC and JDBC connection protocols, see:

  • Introduction to JDBC
  • Creating remote servers using Sybase Central

Connection information    Lets you specify startup connection parameters, such as the name and address of the server.

For ODBC data sources, type the name of the data source. For JDBC access, type a computer name or IP address and a port number in the form hostname:portnumber.

Test Connection    Click this button to test whether the information provided in the remote server definition results in a proper connection.

• CREATE SERVER statement
• Working with remote servers