If you wish to use Sybase IQ as an Open Server, you must ensure that it is started using the TCP/IP protocol. By default, all available communications protocols are started by the server, but you can limit the protocols started by listing them explicitly on the command line. For example, the following command lines are both valid:
start_asiq -x tcpip,ipx other_server_switches asiqdemo.db start_asiq -x tcpip -n myserver other_server_switches asiqdemo.db
The first command line uses both TCP/IP and IPX protocols, of which TCP/IP is available for use by Open Client applications. The second line uses only TCP/IP.
The server can serve other applications through the TCP/IP protocol or other protocols using the Sybase IQ-specific application protocol at the same time as serving Open Client applications over TDS.
Every application using TCP/IP on a machine uses a distinct TCP/IP port, so that network packets end up at the right application. The default port for Sybase IQ is port 2638, which is used for shared memory communications. You can specify a different port number with the Port network option:
start_asiq -x tcpip(Port=2629) -n myserver asiqdemo.db
To connect to this server, the interfaces file at the client machine must contain an entry specifying the machine name on which the database server is running, and the TCP/IP port it uses.
For details on setting up the client machine, see “Configuring IQ Servers with DSEDIT”.
