Mimer SQL connection strings

Mimer Data Provider

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.