Connection strings Examples for Mimer SQL - Connectionstring Examples

Connection strings Examples for Mimer SQL

.NET Data Provider for ODBC

This is a .NET Class Library from Microsoft. The namespace for this provider is System.Data.Odbc.OdbcConnection.

Standard:

Driver={MIMER};Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

Note: You can view more ODBC connection strings for other data provider from other pages.

Mimer .NET Data Provider

This is a .NET driver from Mimer. The usage for this provider is Mimer.Data.Client.MimerConnection.

Standard Local Connection:

Database=yourDataBase;Protocol=local;User Id=yourUsername;Password=yourPassword;

Using Windows Security:

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

Note: 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

Database=yourDataBase;Protocol=local;User Id=yourUsername;Password=yourPassword;Persist Security Info=true;

Note: Password information remain in the connectionstring during the lifetime of the connection.

Using TCP/IP:

Protocol=tcp;Node=yourServerAddress;Service=1333;Database=yourDataBase;User Id=yourUsername;Password=yourPassword;

Using Named Pipes protocol:

Protocol=NamedPipes;Service=yourServerAddress;Database=yourDataBase;User Id=yourUsername;Password=yourPassword;

Mimer ODBC Driver

This is a ODBC driver from Mimer. The usge for this provider is Driver={MIMER}.

Standard:

Driver={MIMER};Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

Note: You can get more information from the Mimer Developer site.

Prompt for username and password:

Driver={MIMER};Database=yourDataBase;