Contents

Starting the server on Windows NT

26

Starting the server from the NT Start menu

26

Typing the server startup command

26

Running the server outside the current session

27

Using command-line switches

28

Naming the server and databases

31

Controlling performance from the command line

33

Controlling permissions from the command line

36

Setting a maximum Catalog page size

37

Setting up a client/server environment

38

Starting a server in forced recovery mode

40

Starting a server from DBISQL

40

Starting multiple servers or clients on the same machine

41

Monitoring server activity

41

Stopping the database server

43

Who can stop the server?

45

Shutting down operating system sessions

45

Starting and stopping databases

46

Starting the asiqdemo database

47

Starting and stopping Sybase Central

48

Connecting a plug-in

49

Stopping Sybase Central

50

Introduction to connections

50

How connections are established

51

Connection parameters specify connections

52

Connection parameters are passed as connection strings

52

Connection parameters are passed as connection strings

53

Simple connection examples

53

Connecting to a database from DBISQL

54

Connecting to other databases from DBISQL

56

Connecting to an embedded database

57

Connecting using a data source

59

Connecting to a server on a network

60

Using default connection parameters

61

Connecting from Adaptive Server IQ utilities

62

Working with ODBC data sources

63

DSNs and FILEDSNs

64

Creating and editing ODBC data sources

65

Configuring ODBC data sources

67

Creating a File Data Source

71

Using ODBC data sources on UNIX

72

Connection parameters

73

Connection parameter priorities

76

How Adaptive Server IQ makes connections

77

iv

Page 4
Image 4
Sybase 12.4.2 manual Contents