Sybase 12.4.2 manual To connect from a Windows NT system

CHAPTER 2 Running Adaptive Server IQ

%cp $SYBASE/asiq12/tix/default.tix

This file controls key sequences for DBISQL and improves the command window display. For more information, see Chapter 6, “Getting Started with DBISQL” in Introduction to Adaptive Server IQ.

4 Start DBISQL by entering

dbisql -c

"uid=DBA;pwd=SQL;eng=servername;links=tcpip"

at the command line. Make sure that the value supplied for the servername is the same server name that was supplied in the start_asiq command to start the server.

The –cparameter specifies connection parameters. You can also specify these parameters in a data source, as described later in this chapter.

Note links=tcpip (or CommLinks=tcpip) is only required if you use TCP/IP to connect to the database. If you use the shared memory port to connect to a local database you can omit the links parameter; however, it is always safer—and required on some platforms—to include complete network parameters.

To connect to a database on a foreign host, you must add the host. For example:

dbisql -c "uid=DBA;pwd=SQL;eng=SERV1_asiqdemo; links=tcpip(host=SERV2)"

If the host was started with a non-default port number (not 2638) then the port number must be added also. For example:

dbisql -c "uid=DBA;pwd=SQL;eng=SERV1_asiqdemo; links=tcpip(host=SERV2;port=1234)"

If you prefer, use this alternate form of the links clause, which has the same result:

links=tcpip(host=SERV2:1234)"

❖To connect from a Windows NT system

1Select Start → Προγραμσ → Sybase Adaptive Server IQ 12 → Interactive SQL, or at the NT command prompt enter

dbisql

55