beautypg.com

Sybase 12.4.2 User Manual

Page 89

background image

CHAPTER 2 Running Adaptive Server IQ

69

Login tab

Use integrated login

Connects using an integrated login. The User ID and

password do not need to be specified. To use this type of login users must have
been granted integrated login permission. The database being connected to
must also be set up to accept integrated logins. Only users with DBA access
can administer integrated login permissions.

For more information, see “Using integrated logins” on page 87.

User ID

Provide a place for you to enter the User ID for the connection.

Password

Provides a place for you to enter the password for the

connection.

Encrypt password

Check this box if you wish the password to be stored

in encrypted form in the profile.

For more information, on User ID, Password, and Encrypt password, see the
chapter “Connection and Communication Parameters” in the Adaptive Server
IQ Reference Manual
.

Database tab

Server name

Provides a place for you to enter the name of the IQ server.

Start line

Enter the server that should be started. Only provide a Start Line

parameter if a database server is being connected to that is not currently
running. For example:

C:\Program Files\Sybase\ASIQ12\win32\asiqsrv12.exe

-gm 10 -gp 4096 -c 8M

dbf=path\asiqdemo.db

uid=DBA pwd=SQL

Database name

Provides a place for you to enter the name of the Adaptive

Server IQ database that you wish to connect to.

Database file

Provides a place for you to enter the full path and name of

the Adaptive Server IQ database file on the server machine. You can also click
Browse to locate the file. For example:

C:\Program Files\Sybase\ASIQ12\demo\asiqdemo.db

Automatically shut down database after last disconnect

Selecting this

will cause the automatic shutdown of the server after the last user has
disconnected.