Sybase 12.4.2 manual Configuring your database for use with Open Client, 490

Setting up Adaptive Server IQ as an Open Server

	asiqdemo.db
	On UNIX, you can use the start_asiq utility in place of asiqsrv12.
	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 Adaptive Server IQ-specific application protocol at the
	same time as serving Open Client applications over TDS.
Port numbers	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
	Adaptive Server IQ is port 2638, which is used for shared memory
	communications. You can specify a different port number with the Port
	network option:
	asiqsrv12 -x tcpip(Port=2629) -n myserver asiqdemo.db
	On UNIX you can include this parameter in the start_asiq command.
Open Client settings	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”.

Configuring your database for use with Open Client

Ensure your database is compatible

Your database must be Adaptive Server IQ 12.0 or higher.

If you are using Adaptive Server IQ together with Adaptive Server Enterprise, you should ensure that your database is created for maximum compatibility with Adaptive Server Enterprise.

When connecting to Adaptive Server IQ as an Open Server, applications frequently assume services they expect under Adaptive Server Enterprise (or SQL Server) are provided. These services are not always present.

For information on creating Adaptive Server Enterprise-compatible databases, see the appendix “Transact-SQL Compatibility” in the Adaptive Server IQ Reference Manual.

490