Connection strings for Mimer SQL

Mimer Data Provider

Type .NET Framework Class Library
 Usage Mimer.Data.Client.MimerConnection
 Manufacturer Mimer
More info and class library downloads

Set 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
More info and driver downloads

Set example values

Standard Security

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

Prompt for username and password

    
Driver={MIMER};Database=myDataBase;
 
 

.NET Framework Data Provider for ODBC

Type .NET Framework Wrapper Class Library
 Usage System.Data.Odbc.OdbcConnection
 Manufacturer Microsoft
More info and wrapper class library downloads

Set example values

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.

 
 

Popular