ASA Database Administration Guide
Connecting to a Database
Working with ODBC data sources
Configuring ODBC data sources using the ODBC Administrator
This tab provides fields for controlling client/server communications over a network.
Select the network protocols and options These checkboxes specify what protocol or protocols the ODBC DSN uses to access a network database server. In the adjacent boxes, you may enter communication parameters that establish and tune connections from your client application to a database.
TCP/IP If you want to use ECC_TLS (Certicom) or RSA_TLS encryption for network packets, you must select the TCP/IP protocol to access the network database server.
For example, you could enter the following communication parameters for a TCP/IP connection HOST=my_server;PORT=4563.
SPX You can select the SPX protocol to connect to databases on Novell NetWare networks. NetWare also supports the TCP/IP protocol.
Named pipes The Named Pipes protocol is used for client/server communication on the same machine. If you want to run under a certified security environment, you can use the Named Pipes protocol. It is only provided on Windows NT/2000/XP.
Shared memory The shared memory protocol is used for communication between a client and server running under the same operating system on the same machine.
For more information, see CommLinks connection parameter [LINKS], and Network communications parameters.
Liveness timeout A liveness packet is sent across a client/server to confirm that a connection is intact. If the client runs for the liveness timeout period without detecting a liveness packet, the communication will be severed. This parameter works only with the network server and TCP/IP and SPX communications protocols. The default is 120 seconds.
For more information, see LivenessTimeout connection parameter [LTO].
Idle timeout Set the amount of client idle time before the connection is terminated. If a client runs for the idle timeout period without submitting a request, the connection is severed.
The default client idle time is 240 minutes.
For more information, see Idle connection parameter [IDLE].
Buffer size Sets the maximum size of communication packets, in bytes. The default buffer size is 1460.
For more information, see CommBufferSize connection parameter [CBSIZE].
Compress network packets Sets compression for the connection. Using compression for a connection can significantly improve Adaptive Server Anywhere performance under some circumstances.
For more information, see Compress connection parameter [COMP].
Select the method for encryption of network packets Allows the encryption of packets transmitted from the client machine over the network.
None Communication packets transmitted from the client are not encrypted. This is the default setting.
Simple Communication packets transmitted from the client are encrypted with simple encryption. Simple encryption is supported on all platforms, as well as on previous versions of Adaptive Server Anywhere.
ECC TLS Communication packets transmitted from the client are encrypted with ECC_TLS (formerly Certicom) encryption. This is a type of strong encryption. It is only available over the TCP/IP protocol.
In the adjacent field you must supply a trusted certificate value.
RSA TLS Communication packets transmitted from the client are encrypted with RSA_TLS encryption. This is a type of strong encryption. It is only available over the TCP/IP protocol.
In the adjacent field you must supply a trusted certificate value.
For more information, see Encryption connection parameter [ENC].