CREATE SERVER statement
464
CREATE SERVER statement
Use this statement to add a server to the SYSSERVERS system table.
CREATE SERVER
server-name
CLASS ’
server-class
’
USING ’
connection-info
’
[ READ ONLY ]
server-class
:
{ ASAJDBC | ASEJDBC
| ASAODBC | ASEODBC
| DB2ODBC | MSSODBC
| ORAODBC | ODBC }
connection-info
:
{
machine-name:port-number
[
/dbname
] |
data-source-name
}
Must have RESOURCE authority.
Supported on Windows 95 and Windows NT only.
Automatic commit.
"ALTER SERVER statement" on page 390
"DROP SERVER statement" on page 511
"Server Classes for Remote Data Access" on page 925 of the book ASA
User’s Guide
The CREATE SERVER statement defines a remote server from the Adaptive
Server Anywhere catalogs.
$ For more information on server classes and how to configure a server,
see "Server Classes for Remote Data Access" on page 925 of the book ASA
User’s Guide.
USING clause If a JDBC-based server class is used, the USING clause is
of the form hostname:portnumber [/dbname], where:
♦
hostname is the machine the remote server runs on
♦
portnumber is the TCP/IP port number the remote server listens on.
The default port number for Adaptive Server Anywhere is 2638.
♦
dbname For Adaptive Server Anywhere remote servers, if you do not
specify a dbname, then the default database is used. For Adaptive Server
Enterprise, the default is the master database, and an alternative to using
dbname is to another database by some other means (for example, in the
FORWARD TO statement).
If an ODBC-based server class is used, the USING clause is the data-source-
name. The data-source-name is the ODBC Data Source Name.
Function
Syntax
Permissions
Side effects
See also
Description
Parameters
To Next Page
Loading...