Using SQL Anywhere Database with a Web Services Server - Creating a web services server to work with the database
(Page 2 of 4 )
In this step, using appropriate command line arguments, a web services server will be created to work with the above database. Type in the following command: dbeng9 -xs http(port:8082) mysorian.db at the command prompt as shown. Since port 80 is already being used by the IIS server, port 8082 (or a different one of your choice) was used. The HTTP listener will be at Port 8082.
This will log all the information related to mysorian server as shown in this screen. Keep this screen up and it stays minimized on the desktop with the title icon showing.
Now bring up Sybase Central, and click on Connect, accessible from the menu item Tools. This brings up the following screen, where you choose the option to connect to Adaptive Server Anywhere 9.
When you click OK you will get the following screen, where you enter the authentication information as shown. The User ID is dba and the Password (case sensitive) is sql.
Now click on the tab Database and click on the button Find...to search for the database name. The program searches all the available servers and then you will be asked to choose from the servers to connect to as shown:
Now click on mysorian and click OK. You will get the following screen, where you need to find the database file. If you look back and review the log created while installing, you will see the database file is located at C:\Program files\Sybase\SQL Anywhere 9\win32\mysorian.db. Now use the browse button to locate this file as shown.
When you click OK, you will see that mysorian is added to Sybase Central's list of server nodes as shown. Currently this database is quite empty except for the system tables as discussed earlier.
Now using Interactive SQL, a utility that comes with the installation, you create database objects. You can also use the built-in utility to import into SQLAnywhere the data of your choice, or by using other third party products, database objects can be imported.
Next: Verifying Installation >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
