You must run a separate CREATE SERVER statement 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 database server 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, see CREATE SERVER statement.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |