Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » ODBC Configuration Dialog Help » SQL Anywhere ODBC driver

ODBC Configuration dialog: Database tab Next Page

ODBC Configuration dialog: Network tab


The Network tab of the ODBC Configuration dialog has the following components:

TCP/IP    If you want to use ECC_TLS (formerly Certicom) or RSA_TLS strong encryption for network packets, you must select the TCP/IP protocol to access the network database server. In the adjacent field, you may enter communication parameters that establish and tune the connection from your client application to a database.

For example, to look on the computer server1 on port 4436 for a database server, you would enter HOST=server1;PORT=4436.

Contact your network administrator if you are unsure which protocol to use.

SPX    You can select the SPX protocol to connect to databases on Novell NetWare networks. NetWare also supports the TCP/IP protocol. In the adjacent field, you may type communication parameters that establish and tune the connection from your client application to a database.

For example, you could enter the following communication parameters for an SPX connection HOST=0:0:0:0:0:1/4:236:121:215;PORT=2369.

Contact your network administrator if you are unsure which protocol to use.

Shared memory    The shared memory protocol is used for communication between a client and server running under the same operating system on the same computer.

Contact your network administrator if you are unsure which protocol to use.

For more information, see CommLinks connection parameter [LINKS], and Network protocol options.

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 is severed. This parameter only works with network server and TCP/IP or IPX communication protocols.

The default liveness timeout 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.

Buffer size    Set the maximum size of communication packets, in bytes. You should set the buffer size to be smaller than that allowed by your network because the network software may add information to each buffer before sending it over the network.

The default buffer size is 1460 bytes.

For more information, see CommBufferSize connection parameter [CBSIZE].

Compress network packets    Select this option to turn on compression for the connection. Using compression for a connection can significantly improve SQL 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 computer over the network.

Separately licensed component required

ECC encryption and FIPS-certified encryption require a separate license. All strong encryption technologies are subject to export regulations.

See Separately licensed components.

See also