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 select a different software platform from the dropdown list to change the server type.
The server type that you select restricts the types of connection you can choose from. For example, if you select Generic Server from the Server Type dropdown list, you can only connect using ODBC.
Connection type Lets you choose between the and 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 Adaptive Server 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 and .
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 machine 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.