connect to...disconnect

Description

Component Integration Services only Connects to the specified server and disconnects the connected server.

Syntax

Syntax 1 This syntax is sent to Adaptive Server verbatim. Use this syntax with Component Integration Services (CIS) to create a passthru to a different server.

connect to server_name
disconnect
	[from ASE]
	[all]
	[connection_name]

Syntax 2 This syntax opens a new JDBC-level connection to Adaptive Server, and does not use CIS. You can specify the arguments in any order. If you do not include an arguments, Adaptive Server prompts you for connection parameters.

connect
	[to ASE engine_name]
	[database database_name]
	[as connection_name]
	[user user_id]
	[identified by password]]]

Syntax 3 This syntax opens a new JDBC-level connection to Adaptive Server. This syntax does not use CIS:

connect using connect_string

Parameters

server_name: is the server to which a passthrough connection is required.

from ASE: disconnects from the current Adaptive Server.

all: disconnects from all Adaptive Servers.

connection_name: disconnects from the specified connection.

engine_name: connect to the specified engine.

database_name: connects to the specified database.

connection_name: connect to the configured connection.

user_id: connect to the user with this ID.

connection_string: connects using a predetermine connection string.

Examples

Example 1

Establishes a passthrough connection to the server named SYBASE:

connect to SYBASE

Example 2

Disconnects the connected server:

disconnect

Example 3

Disconnects from all servers:

disconnect all

Usage

connect to specifies the server to which a passthrough connection is required. Passthrough mode enables you to perform native operations on a remote server.
server_name must be the name of a server in the sysservers table, with its server class and network name defined.
When establishing a connection to server_name on behalf of the user, Component Integration Services uses one of the following identifiers:
- A remote login alias described in sysattributes, if present
- The user’s name and password
In either case, if the connection cannot be made to the specified server, Adaptive Server returns an error message.
For more information about adding remote servers, see sp_addserver.
After making a passthrough connection, Component Integration Services bypasses the Transact-SQL parser and compiler when subsequent language text is received. It passes statements directly to the specified server, and converts the results into a form that can be recognized by the Open Client interface and returned to the client program.
To close the connection created by the connect to command, use the disconnect command. You can use this command only after the connection has been made using connect to.
You can abbreviate the disconnect command to disc.
The disconnect command returns an error unless connect to has been previously issued and the server is connected to a remote server.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Permission to use the connect to command must be explicitly granted by the System Administrator. The syntax is:

grant connect to user_name

The System Administrator can grant or revoke connect permission to public globally while in the master database. If the System Administrator wants to grant or revoke connect to permission for a particular user, the user must be a valid user of the master database, and the System Administrator must first revoke permission from public as follows:

use master
go
revoke connect from public
go
sp_adduser fred
go
grant connect to fred
go

Auditing

Values in event and extrainfo columns of sysaudits are:

Event	Audit option	Command or access audited	Information in extrainfo
90	security	connect to	Roles – Current active roles Keywords or options – connect to Previous value – NULL Current value – NULL Other information – NULL Proxy information – Original login name, if set proxy in effect