Mimer SQL connection strings

Mimer Data Provider

  • 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.

Problems connecting?
Get answer in the Mimer SQL Q & A forum

Mimer ODBC Driver

.NET Framework Data Provider for ODBC

  • 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.

Q&Aask question »

Articlesread all »

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.