Mimer SQL on Windows NT4/2000/XP/2003

This article will give a short introduction to Mimer SQL Engine for the Windows NT4, 2000, XP and 2003 platform.

Mimer SQL for Windows is designed and engineered to integrate well into the operating system environment. Every Windows NT administrator can feel confident using Mimer SQL Engine since the product relies both on standard, basic NT administration tools, and Mimer specific tools which fit well together into the shell environment.

Examples of features included:

  • Easy and user-friendly installation. You will have your first database server running in minutes.

  • A silent install option if you want to install Mimer SQL Engine for Windows as part of your product.

  • A Windows NT system service is created automatically when you create a database. Databases can be controlled using the System Service Control Panel.

  • Clients can connect to the database server using the Named Pipes network protocol and thereby using the Windows NT system security.

  • Administrators can measure database usage seamlessly using the Windows NT Performance Monitor.

  • Mimer SQL Engine makes use of the Windows NT Event Log for error logging.

  • Standard Windows NT uninstall.


Mimer SQL Engine comes with a JDBC driver entirely written in Java. This enables you to use Mimer SQL in all Java environments, from browsers to enterprise servers. The JDBC driver is also distributed separately. The JDBC-driver supports Mimer SQL Engine from version 8.2 and later.

Mimer SQL Engine also comes with an ODBC 3.52 compliant driver. ODBC is currently the major application interface on Windows. The Mimer ODBC implementation is a complete implementation which makes Mimer compatible with any ODBC compliant application. The ODBC-driver supports 7.2 database servers and later.

Microsoft ADO and OLE DB is also supported by Mimer SQL Engine.

Mimer SQL Engine is platform independent, so you can use Mimer SQL clients to connect to a Mimer SQL database server on any platform.

Enabling the JDBC Driver

In order to use JDBC with the application or application server of your choice you need to configure the application to use the Mimer JDBC Driver. For most applications this means that the application should be started with the JDBC-driver in the classpath, and that the application should be made aware of the Mimer JDBC Class name.

The below sample command line statement starts your application with the correct classpath. If you chose to install Mimer in a non-default directory, you must replace the below path with the directory of your choice.

java -cp "%CLASSPATH%;c:\program files\mimer82 nt\mimjdbc-1_3.jar" MyApp

This is also covered in more detail in the Mimer JDBC User’s Guide, which comes with the product. Also, on this website, see specific instructions on how to enable your tool with Mimer SQL.

Silent Install for Value Added Resellers

Mimer SQL Engine for Windows makes it possible for you to distribute Mimer SQL Engine with your application, you probably want to install Mimer SQL silently with a predefined set of options. However, this is neither within the scope of the free developer license nor this article. Please contact Mimer SQL Support for a license and instructions.

Using the Named Pipes Network Protocol

Using the Microsoft specific Named Pipes protocol has several benefits. Some of the extra features provided the protocol are:

  • The protocol takes advantage of the built in Windows NT security system. Clients connecting to a server must be approved by the Windows server security system.

  • It makes it possible to automatically login to the database using the NT security system. Clients connecting to the server must be logged on to the Windows NT domain of the server.

  • It is slightly faster than TCP on Windows.

Please note that Named Pipes is a Windows specific network protocol. A Mimer SQL server accepting only Names Pipes will only be able to accept connections from Windows clients.

To be able to rely entirely on the Windows NT security system, you may want to deny TCP-connections. You can configure this using the Mimer Administrator, which you will find in the Start-menu. Click the Communication tab to display the settings, for example:

The above example shows the dialog when TCP/IP connections are disabled, but Named Pipes and shared memory communication are enabled.

For more information on the specific items covered in this article, see below:

Microsoft Windows:


How To Get Started with Mimer JDBC

Download Mimer SQL Engine for Windows 2000/2003/XP from our download page.

For further details, please see our Howto and Feature articles. Or, contact Mimer SQL Support.

Last updated: 2004-09-07


Powered by Mimer SQL

Powered by Mimer SQL