Introducing SQL Anywhere Studio
Tutorial: Connecting to the Sample Database
Adaptive Server Anywhere databases are held in files on disk. The Adaptive Server Anywhere database server is the piece of software that manages the database. All access to your database must be made through a database server.
Adaptive Server Anywhere comes with two versions of its database server. The first is called the personal server. It can accept connections from applications or users running on the same machine. By contrast, the network server also accepts connections from applications or users on other computers by means of the network, which links the two machines. Apart from this difference, these two versions of the database server perform the same tasks and are virtually identical.
The database server allows access to databases from client applications, and processes commands in a secure and efficient manner. Only one database server at a time can manage any one database.
In this tutorial you start the database server running the sample database. You then connect to the database from Interactive SQL and send a command to the database. The tutorial leads you through creating an ODBC data source to hold connection information, and finishes by shutting down the database server.
The tutorial takes about ten minutes.
The tutorial provides you with the basic skills of running a database server and connecting to it. These skills are assumed elsewhere in the documentation.