Remote Server Properties window: General tab

This tab has the following components:

  • Name   Shows the name of the remote server.

  • Type   Shows the type of object.

  • Read-only   Shows whether 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.

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 database 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 database server types: Sybase SQL Anywhere,Sybase Adaptive Server Enterprise and Sybase IQ. 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 JDBC support and ODBC support.

  • Connection information   Lets you specify startup connection parameters, such as the name and address of the database 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.

 See also