Introduction

---

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

Definition	Description
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.

Abbreviation	Short for	Description
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.

1.3 References

[1] InstallShield 2008 Professional Edition, Getting Started

[2] Mimer SQL Reference Manual

[3] Mimer SQL System Management Handbook

[4] 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 info@mimer.se