Connection strings for Mimer SQL
Providers for Mimer SQL
Community Forums
Find solutions and post questions regarding connection string related issues.
Mimer Data Provider
Type
.NET Framework Class Library
Usage Mimer.Data.Client.MimerConnection
Manufacturer Mimer
Usage Mimer.Data.Client.MimerConnection
Manufacturer Mimer
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
Usage Driver={MIMER}
Manufacturer Mimer
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
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
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;
Selected Articles