# Database: Sybase Server

## Sybase Adaptive Server Anywhere

The Sybase Adaptive Server Anywhere version 6.0 comes as a 60-day trial version with the SQL: The Complete Reference (SQLCR). This server is a good implementation of SQL, is easy to install, and doesn't take a lot of disk space.

## Installing

Follow the directions starting on p.956 of SQLCR.

## Starting and Stopping the Server

Start the server by choosing:
Start | Programs | Sybase | Adaptive Server Anywhere 6.0 | Personal Server Sample
Now the server is running, but it has no user interface. For that you need to run some other program (see below).

To stop the server double click the server icon in the system tray, then click on the shutdown button.

## Using the Interactive SQL Interface

1. Start the Interactive SQL client with
   Start | Programs | Sybase | Adaptive Server Anywhere 6.0 | Interactive SQL.
   Buried deep in the help file (SQL Anywhere Studio: A First Guide, Part 2, Chapter 3) it gives some instructions for using Interactive SQL, summarized in the next steps.
2. To make a connection to a database, use ID DBA and password SQL.
3. The sample database should now be open. Type SQL commands in the bottom pane of the window and results will appear in the top pane.

## The Sample Database

The sample database that comes with this trial version of Sybase is described in the help file (Sybase Anywhere Studio: A First Guide, Part 1, Chapter 1).

## Using Sybase via ODBC

See the help file: SQL Anywhere Studio: A First Guide, Part 2, Chapter 3. But I haven't tried it yet, for example to connect using WinSQL.

## Using Sybase Central

The Sybase Central program can be used to create and otherwise manage databases.