Deploying SQL Anywhere files

If your InfoMaker application uses a SQL Anywhere database, you need to deploy the SQL Anywhere database as well as SQL Anywhere’s ODBC database drivers.

NoteRestrictions InfoMaker includes SQL Anywhere for use during the development process. However, this product cannot be deployed royalty-free to your users.

If your application requires the data definition language (DDL), a transaction log, stored procedures, or triggers, see your Sybase sales representative.

If your application uses a standalone database, you can deploy the SQL Anywhere Desktop Runtime System to users’ computers without incurring additional license fees. The runtime system allows the user to retrieve and modify data in the database, but does not allow modifications to the database schema. It does not support transaction logs, stored procedures, or triggers.

A full installation for the SQL Anywhere driver, runtime engine, and supporting files is available in the Support\SA10Runtime directory on the CD. Table 22-3 lists some of the files that are installed. For more information see the RuntimeEdition.html file in the installed directory.

Table 22-3: SQL Anywhere files

Name

Description

DBODBC11.DLL

SQL Anywhere ODBC driver

DBBACKUP.EXE

SQL Anywhere backup utility

DBCON11.DLL

Connection dialog box, required if you do not provide your own dialog box and your end users are to create their own data sources, if they need to enter user IDs and passwords when connecting to the database, or if they need to display the Connection dialog box for any other purpose

DBISQLC.EXE

Interactive SQL utility

DBLGEN11.DLL

Language-specific string library (EN indicates the English version)

DBLIB11.DLL

Interface library

DBTOOL11.DLL

SQL Anywhere database tools

DBUNLSPT.EXE

SQL Anywhere unload utility

DBVALID.EXE

SQL Anywhere validation utility

DBENG11.EXE

Restricted runtime engine

DBCTRS11.DLL

Performance utility

DBSERV11.DLL

Server utility

In addition to deploying database files and drivers, you need to do the following for your users:

For more information about deploying SQL Anywhere databases and applications, see the SQL Anywhere documentation.