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 'saodbc' USING 'banana:2638/db1' CREATE SERVER TestSAdb2 CLASS 'saodbc' USING 'banana:2638/db2' CREATE SERVER TestSAdb3 CLASS 'saodbc' 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.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |