Filter
Top Products
Setting up Adaptive Server IQ as an Open Server
490
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
Your database must be Adaptive Server IQ 12.0 or higher.
Ensure your database
is compatible
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.