Using SQL Anywhere Database with a Web Services Server
(Page 1 of 4 )
This article explains how to create a web services server that works with the
SQL Anywhere database. The entire process, from creating the database through verifying installation of the web service, will be described.
Introduction
In Part 1, installation of SQL Anywhere Studio 9.0 and using the Sybase Central; Interactive SQL; and details about database objects were presented. In Part 2, creating database projects with SQL Anywhere Studio was described in detail, with examples of Excel, VB, and ADO.NET applications. In this tutorial, the creation of a web services server that works with the SQLAnywhere database will be described. A very simple example to verify the web services server will be shown.
Creating a SQLAnywhere database
SQL Anywhere 9.0 is installed at the following location on my computer: C:\Program Files\Sybase\SQL Anywhere 9\win32, which has all the executable files. A database can be created by executing the command -dbinit.exe. The dbinit.exe is executed from the command line (Start -->Run-->change to the above directory) as shown below. Make sure your Asademo 9 server is running before you execute the command. At the command prompt type dbinit mysorian.db. The name of the database created is mysorian.db. The collation default is set to 1252 Latin collation. During the execution, the system tables are created, and the deployment option for Ultralite is also set.
This creates a new database, mysorian.db. In the following step, a web services server will be installed which works with the Sybase Central User interface.
Next: Creating a web services server to work with the database >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
