Connection strings for Mimer SQL

Mimer Data Provider

Type .NET Framework Class Library
Usage Mimer.Data.Client.MimerConnection
Manufacturer Mimer

Standard local connection

Database=myDataBase;Protocol=local;User Id=myUsername;Password=myPassword;

Using Windows Security

Database=myDataBase;Protocol=local;Integrated Security=true;

This type of login succeeds if there is an ident of type OS_USER with the same name as the Windows user.


Persist security info

Use this one to let the password information remain in the connection string after the connection have been opened.

Database=myDataBase;Protocol=local;User Id=myUsername;Password=myPassword;
Persist Security Info=true;

Using TCP/IP

Protocol=tcp;Node=myServerAddress;Service=1333;Database=myDataBase;User Id=myUsername;

Note that the "Service" key is used to specify what TCP port to use.


Using Named Pipes protocol

Protocol=NamedPipes;Service=myServerAddress;Database=myDataBase;User Id=myUsername;

Note that the "Service" key is used to specify what server to connect to.


Mimer ODBC Driver

Type ODBC Driver
Usage Driver={MIMER}
Manufacturer Mimer

Standard Security


Prompt for username and password


.NET Framework Data Provider for ODBC

Type .NET Framework Wrapper Class Library
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft

Use an ODBC driver from .NET

Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.