Sybase 12.4.2 Connecting from Adaptive Server IQ utilities, You may connect to the wrong server

Simple connection examples

	pwd=password
	Note Do not use these parameters if more than one local server is running, or
	you may connect to the wrong server.
Default database
	If more than one server is running, you need to specify which one you wish to
	connect to. If only one database has been started on that server, you do not need
	to specify the database name. The following connection string connects to a
	named server, using the default database:
	eng=server_name
	uid=user_id
	pwd=password
No defaults	The following connection string connects to a named server, using a named
	database:
	eng=server_name
	dbn=db_name
	uid=user_id
	pwd=password
	For more information about default behavior, see “How Adaptive Server IQ
	makes connections”.

Connecting from Adaptive Server IQ utilities

Adaptive Server IQ database utilities that communicate with the server (rather than acting directly on database files) do so using Embedded SQL. They follow the procedure outlined in “How Adaptive Server IQ makes connections” when connecting to a database.

How database utilities Many of the administration utilities obtain the connection parameter values by: obtain connection

parameter values 1 Using values specified on the command line (if there are any). For example, the following command starts the collation utility on the sample database on the default server, using the user ID DBA and the password SQL and the asiqdemo.col collation file:

dbcollat -c "uid=DBA;pwd=SQL;dbn=asiqdemo" c:\temp\asiqdemo.col

62