The purpose of this document is to describe how the relational database system Mimer SQL can be packaged together with an application.
By including Mimer SQL, end-users can install both the application and Mimer SQL in a single installation.
The document describes in detail how this is performed in a Windows environment with Mimer SQL version 9.3 or later. The following Windows operating systems are supported: Vista, XP, 2003, and 2000.
The document is intended for Value Added Resellers (VAR's) that package and sell Mimer SQL together with their own application.
1.1 Document Overview
This document describes how to create an installation package that can install Mimer SQL together with an application.
The installation package will perform the following:
- Run a silent setup of Mimer SQL. There are two ways of doing this: using InstallShield or writing your own Setup program. Methods for Creating a Silent Mimer SQL Installation for more information.
- Add a Mimer SQL license key, see Adding a Mimer SQL License Key.
- Define a database, see Defining a Database.
- Generate the system databanks, see Generating the System Databanks.
- Start the database server, see Starting the Database Server.
- Create the database objects needed by the application, see I_CreateApplicationObjects.
The first three steps are sufficient for a Mimer SQL client-only installation.
See About Previous Mimer SQL Versions, to read how the Mimer SQL installation program handles other versions of Mimer SQL on the system where the installation is taking place and how to upgrade already existing Mimer SQL systems from older versions to version 9.3.
1.2 Definitions and Abbreviations
ODBC Data Source The database that the user wants to access and its associated operating system, DBMS and network protocol (if any). ODBC Driver A routine library where the database specific ODBC functions are implemented. Drivers are specific to a single DBMS. ODBC Driver Manager A routine library that manages access to drivers for the application. The Driver Manager loads and unloads drivers and passes calls to ODBC functions to the correct driver.
API Application Programming Interface A documented set of general routines designed for some limited area of use. ODBC Open Database Connectivity Microsoft's specification for an API that defines a standard set of routines with which an application can access data in a data source. SQL Structured Query Language Query and management language for relational databases.
 InstallShield 2008 Professional Edition, Getting Started
 Mimer SQL Reference Manual
 Mimer SQL System Management Handbook
 ODBC 3.0 Programmer's Reference and SDK Guide volumes 1 and 2, Microsoft
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40