Ispirer SQLWays Database Migration Software

ODBC Sybase ASA Driver Setup Dialog: Network Tab

If you are configuring an ODBC DSN for an ASA installation on a remote machine, then you need to fill in connectivity information on the Network tab. The network connection information must be in the format: host=machine_name:port_number, where machine_name is the name of the machine on which the ASA you want to connect runs and port_number is the port number for that ASA. For example:

host=chance:2638

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 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 machine 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.

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.

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 machine.

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

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.

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.

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.

Compress network packets Select this option to turn on compression for the connection. Using compression for a connection can significantly improve Adaptive Server Anywhere performance under some circumstances.

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. Simple encryption is not as strong as ECC_TLS or RSA_TLS encryption.

ECC TLS Select this option to enable ECC_TLS (formerly Certicom) encryption. ECC_TLS encryption protects the confidentiality and integrity of network packets as they pass between the client and the server. It is only available over the TCP/IP protocol.

In the adjacent field you must supply a trusted certificate value. You may also click Edit to supply this value.

RSA TLS Select this option to enable RSA_TLS encryption. RSA_TLS encryption protects the confidentiality and integrity of network packets as they pass between the client and the server. It is only available over the TCP/IP protocol.

In the adjacent field you must supply a trusted certificate value. You may also click Edit to supply this value.

Edit Click Edit to supply Certicom encryption values for trusted certificates, certificate company, certificate unit, and certificate name in the Certicom Encryption Options dialog.

Note that this is unlike the format of the connection string for Adaptive Server Enterprise and the DirectConnects, which use the Open Client format of machine_name,port. For example: chance,5000

Testing the Connection

As noted previously in this section, the ASA driver configuration utility provides a Test Connection button on the ODBC tab. This allows you to verify connectivity while you are still in the driver configuration utility.