User's Guide
   PART 4. Database Administration and Advanced Use
     CHAPTER 27. Deploying Databases and Applications       

Deploying embedded database applications

This section provides information on deploying embedded database applications, where the application and the database both reside on the same machine.

An embedded database application includes the following:

• Client application     This includes the Adaptive Server Anywhere client requirements.

       For information on deploying client applications, see Deploying client applications.

• Database server     The Adaptive Server Anywhere personal database server.

       For information on deploying database servers, see Deploying database servers.

• SQL Remote     If your application uses SQL Remote replication, you must deploy the SQL Remote Message Agent.

• The database     You must deploy a database file holding the data the application uses.

  Deploying personal servers

When you deploy an application that uses the personal server, you need to deploy both the client application components and the database server components.

The language library (dblgen6.dll) is shared between the client and the server. You need only one copy of this file.

It is recommended that you follow the Adaptive Server Anywhere installation behavior, and install the client and server files in the same directory.

Remember to provide the Java zip files and the Java DLL if your application takes advantage of Java in the Database.

  Deploying database utilities and Interactive SQL

If you need to deploy database utilities (such as dbbackup.exe) along with your application, then you need the utility executable together with the following additional files:

Description	32-bit Windows	Windows 3.x	UNIX
Database tools library	dbtools6.dll	dbtools6w.dll	dbtools.so
Additional library	dbwtsp6.dll	dbwtsp6w.dll	dbwtsp6.so
Language library	dblgen6.dll	dblgen6w.dll	dblgen6.res
Connection dialog (Interactive SQL only)	dbcon6.dll	dbcon6w.dll

Notes 

• On HP-UX, all files listed with extension .so instead have extension .sl. On AIX, the files have extension .so or .a.

• The database tools are Embedded SQL applications, and you must supply the files required for such applications, as listed in Deploying Embedded SQL clients.

  Deploying SQL Remote

If you are deploying the SQL Remote Message Agent, you need to include the following files:

Description	32-bit Windows	Windows 3.x	UNIX
Message Agent	dbremote.exe	dbremotw.exe	dbremote
Database tools library	dbtools6.dll	dbtools6w.dll	dbtools.so
Additional library	dbwtsp6.dll	dbwtsp6w.dll	dbwtsp6.so
Language library	dblgen6.dll	dblgen6w.dll	dblgen6.res
VIM message link library (1)	dbvim.dll	dbvimw.dll
SMTP message link library (1)	dbsmtp.dll	dbsmtpw.dll
FILE message link library (1)	dbfile.dll	dbfilew.dll	libdbfile.so
MAPI message link library (1)	dbmapi.dll	dbmapiw.dll

1 Only deploy the library for the message link you are using.

Notes 

• It is recommended that you follow the Adaptive Server Anywhere installation behavior, and install the SQL Remote files in the same directory as the Adaptive Server Anywhere files.

• On HP-UX, all files listed with extension .so instead have extension .sl. On AIX, the files have extension .so or .a.