Creating Database Projects with SQL Anywhere Studio, Part 1 - Sybase Central
(Page 4 of 6 )
Sybase Central is a dashboard for any activity that one may wish to perform on the database. Its functionality is very similar to the SQL 2000 Server's Enterprise Manager. One could use this canvas to carry out many different kinds of activities, such as connecting to and disconnecting from the server, creating databases, creating tables and other objects, etc. If one is familiar with other database products it is quite intuitive.
Both Adaptive Server Anywhere 9.0 and Mobilelink Synchronization are plug-in type JAR files, as seen in the property page of this management panel.
Sybase Central can be activated by clicking its shorcut, shown earlier, which will display a splash screen as seen here. Sybase Central can be activated before or after starting the server.
Connection to the server from Sybase Central can be established in a couple of ways as shown below.
When you click on connect to establish a connection you will encounter this dialog box which requires authentication information[Identifcation tab]. For UserID type in dba and for password type in sql and accept the rest of the defaults and click OK. Proof positive for connection can be acertained by clicking the "Test" button in the ensuing dialogue.
In the Database tab click on the drop-down menu by the side of the label Server Name and you should see the name of the installed server [asademo9]. Now click on Find... and the program starts looking for the server and persents a FindServer dialogue box. If the server has not started then no servers will be found. If you start the server and then click find, you will see the following screen. Using the Browse... button by the side of Database File label, the database files must be located. This can found in the installed location, which in this case was C:\Program Files\Sybase\SQL Anywhere 9\asademo.db. One could also find this location information in the running server, which is minimized in the taskbar.
Next: Database Objects >>
More Database Articles
More By Jayaram Krishnaswamy
/ 10 
