Installation Guide

Chapter 11 Configuring Sybase Adaptive Server Anywhere and SQL Anywhere Databases

This chapter describes how to configure your Sybase Adaptive Server Anywhere (ASA) and Sybase SQL Anywhere database for use within the SilverStream server environment as either a SilverMaster database or an application database.

For the latest information on supported database versions, see the Release Notes. In Windows, you can access theRelease Notes from the SilverStream program group or from SilverStream online help.

This chapter includes these sections:

Overview of Sybase ASA and SQL Anywhere support

SilverStream Application Server Developer Edition includes a special authenticated version of Sybase Adaptive Server Anywhere (ASA). An authenticated version means that it can only be used with SilverStream.

This authenticated version of Sybase ASA allows users that do not already use Sybase ASA to install it at the same time that they install SilverStream. This software is supplied in part because the SilverStream online help system and sample applications are stored in Sybase ASA databases (you can also run the SilverStream help from the file system if you don't want to install Sybase ASA). If you already have Sybase ASA installed, you do not need to install this authenticated version.

Earlier versions of SilverStream included authenticated versions of Sybase SQL Anywhere 5.5.

You can use either Sybase ASA or SQL Anywhere 5.5 as your SilverMaster and as your application databases. For each DBMS, you can use the authenticated version provided with SilverStream or full version purchased from Sybase.

Where to go from here

If you have been using SQL Anywhere 5.5 (probably because you are upgrading from an earlier version of SilverStream), go to Upgrading from SQL Anywhere 5.5.
If you have only Sybase ASA, go to Setting up a Sybase ASA or SQL Anywhere database.

Upgrading from SQL Anywhere 5.5

Read this section if you have been using SQL Anywhere 5.5.

You can choose to:

Continue using SQL Anywhere 5.5 only
Use both ASA and SQL Anywhere 5.5 on the same machine
Upgrade to Sybase ASA and no longer use SQL Anywhere 5.5

Using only SQL Anywhere 5.5

You can continue to use SQL Anywhere 5.5 databases with SilverStream Version 3. If you are upgrading from a previous release of SilverStream, simply specify your existing SQL Anywhere 5.5 SilverMaster when installing SilverStream and add your existing application databases to the server.

But note that if you do not install Sybase ASA you will not be able to look at the SilverStream sample applications or run help from the SilverHelp database.

For more information about setting up your SQL Anywhere 5.5 databases, see Setting up a Sybase ASA or SQL Anywhere database.

Using both Sybase ASA and SQL Anywhere on the same machine

If you want to use both Sybase ASA and SQL Anywhere 5.5 on one machine, you must install them in different directories, and you must have the SQL Anywhere 5.5 directories on your path before the Sybase ASA directories. This ensures that the proper files are used by SQL Anywhere 5.5. You can then access both Sybase ASA and SQL Anywhere 5.5 databases on the same machine.

For more information about setting up your Sybase ASA and SQL Anywhere 5.5 databases, see Setting up a Sybase ASA or SQL Anywhere database.

Upgrading to Sybase ASA

If you want to use only Sybase ASA, you must upgrade your SQL Anywhere 5.5 database files (.db) to ASA before you can use them with the authenticated version of ASA. If the databases are not upgraded, an authentication violation will occur when you attempt to add the SQL Anywhere 5.5 databases to SilverStream.

NOTE If you upgrade a SQL Anywhere 5.5 database file to ASA, you can no longer use the database with SQL Anywhere 5.5. So back up your database files before doing the upgrade.

To upgrade SQL Anywhere 5.5. databases to ASA:

Install Sybase ASA from the SilverStream Installation program. You can choose all the defaults.
From the Adaptive Server Anywhere program group, select Manage Adaptive Server Anywhere.

Sybase Central opens.
Select Upgrade Database from the Adaptive Server Anywhere Utilities list.
Browse to the SQL Anywhere 5.5 database you want to upgrade.
If you want to connect to this database with the Adaptive Server Anywhere ODBC driver, you must create an ODBC datasource for this newly upgraded database.

It is recommended that the old SQL Anywhere 5.5 data source name (DSN) be deleted before doing this and the same DSN name be used for the ASA version of this data source.
Add the database to the SilverStream server as a Sybase ASA database.

For more information about setting up your Sybase ASA databases, see Setting up a Sybase ASA or SQL Anywhere database next.

Setting up a Sybase ASA or SQL Anywhere database

This section describes how to set up either Sybase ASA or SQL Anywhere 5.5 databases to use with SilverStream.

Using Sybase Adaptive Server Anywhere You can install the authenticated version of Sybase ASA from the SilverStream Installation program, which launches the Sybase ASA installation program. You can follow the Sybase ASA wizard and choose all the defaults (including to install the Personal Server edition of Sybase ASA). The installation wizard installs the Sybase ASA for use with SilverStream.

SilverStream connects to Sybase ASA using ODBC or jConnect. The Sybase ODBC driver and jConnect are included as part of the Sybase ASA installation.

To use Sybase ASA for your SilverMaster, all you need to do is install Sybase ASA before installing SilverStream.

When you install SilverStream, specify that you want to use Sybase ASA as your SilverMaster. The SilverStream Installation program will create and configure the SilverMaster database for you (if you ask it to). It will create and use an ODBC connection.
To use Sybase ASA for an application database, you need to set up the database yourself as described in the next section. When you add the database to the SilverStream server, you specify whether you want to use ODBC or jConnect.

Using Sybase SQL Anywhere If you are using Sybase SQL Anywhere as your SilverMaster or as an application database, you need to set up the database yourself as described in the next section.

Setting up the database

To set up a Sybase ASA database as an application database or set up a SQL Anywhere database for use as a SilverMaster or as an application database, do the following:

Create a database using Sybase Central.
Create a user account to be used by the SilverStream server.
Create an ODBC System DSN entry for the database (if you are using ODBC for the database connection).
Configure Sybase ASA or SQL Anywhere to run as a service.

Sybase ASA or SQL Anywhere must be running when you install SilverStream if you want to use an existing database as your SilverMaster.
Install SilverStream.

For information about installing the SilverStream server, see Installing SilverStream on Windows.

The sections that follow explain these steps.

Step 1: Create a database

Before you can install SilverStream, you must first create the actual database and its underlying devices. Use Sybase Central to create the database.

For more information, see the Sybase Central online help.

Step 2: Create user accounts

Sybase ASA and SQL Anywhere provide a default user dba with the password sql. You can use this user name and password pair for your SilverMaster catalog or any other Sybase ASA or SQL Anywhere databases.

However, SilverStream strongly recommends that you set up separate accounts for your SilverMaster and for each application database; this way you can easily tell which applications are hitting your database when and how often, and you can more easily troubleshoot performance problems. For Sybase ASA and SQL Anywhere, make sure this account has at least Resource and Connect privileges.

For more information about setting up user accounts, see the Sybase Central online help.

Step 3: Create the ODBC System DSN entry

If you will be connecting to the database using ODBC (this is a requirement for SQL Anywhere; with Sybase ASA you can use jConnect), you need to create an ODBC entry for the database.

For more information, see Creating ODBC Data Sources.

Step 4: Run Sybase ASA or SQL Anywhere as a service

SilverStream recommends that you run your Sybase ASA or SQL Anywhere databases as a service to make database use and maintenance easier.

For information about running Sybase ASA as a service, see the Sybase ASA online help: Select Start>Programs>Sybase>Adaptive Server Anywhere version>Adaptive Server Anywhere Manual. In the help contents, select ASA User's Guide. Go to "Running the server outside the current session" in Part 1, Chapter 1.

For information about running SQL Anywhere as a service, see the SQL Anywhere online help: Select Start>Programs>Sybase SQL Anywhere 5.0>Sybase SQL Anywhere Manual. In the help contents, select SQL Anywhere User's Guide. Go to Chapter 29, Running Programs as Services," in Part 3.

Troubleshooting

This section describes known problems and workarounds for SQL Anywhere in the SilverStream server environment.

Memory leak SQL Anywhere Versions 5.5.02, 5.5.03, and 5.5.04 were affected by a memory leak that caused SQL Anywhere to allocate an abnormal amount of RAM during certain operations. This problem has been known to occur with the SilverStream server under certain conditions. Contact Sybase for a fix.

Authentication violation If you are receiving an authentication violation when adding an Adaptive Server Anywhere database, check to make sure you have run the ASA upgrade utility if the database was created in SQL Anywhere 5.5.

Also, if you have both ASA and SQL Anywhere 5.5 on the same machine, you might have a path problem. Ensure that the SQL Anywhere 5.5 directories are before the ASA directories on the path, as described in Using both Sybase ASA and SQL Anywhere on the same machine. If this doesn't solve the problem, try renaming dbl50t.dll in the ASA win32 directory.

Installation Guide