How to create a local database on your computer

Instead of connecting to the SoC Sybase server, you may create a local database on your PC. This way you do not need to follow the complicated procedure for connecting through the network. You also have full access to your database, so you can play with the advanced options.

The following instructions assume that you have downloaded (120MB) and installed the SQL Anywhere 9 software (you will be asked to register but registration is free):

http://www.sybase.com/detail?id=1016644

Open Sybase Central

Start -> All Programs -> SQL Anywhere 9 -> Sybase Central

Create a local database

Tools -> Adaptive Server Anywhere 9 -> Create Database

[Next]

[Next]

C:\course [Finish]

Close Sybase Central

You need to create a local database only once!

Follow the instructions below every time you want to use SQL

Open Interactive SQL

Start -> All Programs -> SQL Anywhere 9 -> Adaptive Server Anywhere -> Interactive SQL

Connect to the local database

Go to the Identification tab

User ID : dba

Password: sql

Go to the Database tab

Server name: localhost

Database file: c:\course

Click [OK]

Now you are ready to write SQL commands as usual