Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Server Classes for Remote Data Access » JDBC-based server classes » Server class sajdbc

Server class sajdbc Next Page

USING parameter value in the CREATE SERVER statement

You must perform a separate CREATE SERVER for each SQL Anywhere database you intend to access. For example, if a SQL Anywhere server named TestSA is running on the computer banana and owns three databases (db1, db2, db3), you would configure the local SQL Anywhere similar to this:

CREATE SERVER TestSAdb1
CLASS 'sajdbc'
USING 'banana:2638/db1'
CREATE SERVER TestSAdb2
CLASS 'sajdbc'
USING 'banana:2638/db2'
CREATE SERVER TestSAdb3
CLASS 'sajdbc'
USING 'banana:2638/db3'

If you do not specify a /database-name value, the remote connection uses the remote SQL Anywhere default database.

For more information about the CREATE SERVER statement, see CREATE SERVER statement.