Developers community number 1 connection string reference

Connection strings for Mimer SQL

Providers to use when connecting to Mimer SQL

» Mimer Data Provider (MimerConnection)
» Mimer ODBC Driver
» .NET Framework Data Provider for ODBC (OdbcConnection)

Finding this site useful?

-Say "Thanks" to Andrew Morton and the other contributing developers!

-Thank you! »

Mimer Data Provider

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

Manufacturer: Mimer
More info about this class library »

Customize string
example values »

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;Password=myPassword;

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;Password=myPassword;

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

Customize string
example values »

Standard Security

Driver={MIMER};Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Loading ad...

Prompt for username and password

Driver={MIMER};Database=myDataBase;

Welcome to the Mimer SQL developer site

.NET Framework Data Provider for ODBC

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

Manufacturer: Microsoft
More info about this wrapper class library »

Customize string
example values »

Bridging to Mimer ODBC Driver

This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.

Driver={MIMER};Database=myDataBase;Uid=myUsername;Pwd=myPassword;