Connection parameters
48
The database server may be running on the same machine, or on a different
machine. The client does not attempt to connect using shared memory,
Named Pipes, or DDE. The CommLinks connection parameter must specify
the appropriate protocol for it to be used.
AppInfo connection parameter [App]
To assist administrators in identifying the origin of particular client
connections from a database server.
Anywhere
Empty string
This connection parameter is sent to the database server from
Embedded SQL, ODBC, or OLE DB clients. It is not available from Open
Client or jConnect applications such as Interactive SQL or Sybase Central.
It consists of a generated string that holds information about the client
process, such as the IP address of the client machine, the operating system it
is running on, and so on. The string is associated in the database server with
the connection, and you can retrieve it using the following statement:
select connection_property( ’appinfo’ )
Clients can also specify their own string, which is appended to the generated
string. The AppInfo property string is a sequence of semi-colon-delimited
key=value pairs. The valid keys are as follows:
♦
IP The IP address of the client machine (Unix and NetWare only)
♦
HOST The host name of the client machine
♦
OS The operating system name and version number (for example,
Windows NT 4.0, NetWare 3.12)
♦
PID The process ID of the client (Windows and Unix only)
♦
THREAD The thread ID of the client (Windows and Unix only)
♦
EXE The name of the client executable (Windows and NetWare only)
♦
VERSION The version of the connection protocol in use, including
major and minor values, and a build number (for example 7.0.00.3642)
♦
APPINFO If you specified APPINFO in the connection string, the
string entered.
If you specify a debug log file in your client connection parameters, the
APPINFO string is added to the file.
Function
Usage
Default
Description
To Next Page
Loading...