EffiProz connection strings

EffiProz ADO.NET Provider

  • In-Memory Database

    Connection Type=Memory;Initial Catalog=myDataBase;User=myUsername;
    Password
    =myPassword;
  • File Database

    Connection Type=File;Initial Catalog=C:\myFolder\MyDB;User=myUsername;
    Password
    =myPassword;
  • Embedded Resource Database

    Connection Type=Resource;Initial Catalog=EffiProz.Test.Resources.TestDB;
    User
    =myUsername;Password=myPassword;
  • With Auto Commit

    Connection Type=Memory;Initial Catalog=myDataBase;Auto Commit=True;
    User
    =myUsername;Password=myPassword;
  • With Auto Shutdown

    Connection Type=File;Initial Catalog=C:\myFolder\MyDB;Autoshutdown=True;
    User
    =myUsername;Password=myPassword;
  • Read Only Connection

    Connection Type=Memory;Initial Catalog=myDataBase;Readonly=True;User=myUsername;
    Password
    =myPassword;
  • With Transaction Isolation Level

    Connection Type=Memory;Initial Catalog=myDataBase;Auto Commit=False;
    Isolation level
    =serializable;User=myUsername;Password=myPassword;
  • With Pooling

    Connection Type=Memory;Initial Catalog=myDataBase;Pooling=True;User=myUsername;
    Password
    =myPassword;
  • Enlist in distributed transaction

    Connection Type=File;Initial Catalog=C:\myFolder\MyDB;Enlist=True;
    User
    =myUsername;Password=myPassword;
  • With Encryption

    Connection Type=File;Initial Catalog=C:\myFolder\MyDB;Cipher name=Rijndael;
    Cipher key
    =oOEWVlhLZlOigUFYZVtlQ4SPjZkzg5KEGRXBPLUa6Eo=;
    Cipher iv
    =wVavg5JdMB6jjtpWYyLa4A==;User=myUsername;Password=myPassword;
  • File in My Documents folder

    Connect to a File database in "My Documents" folder from a Silverlight OOB application

    Connection Type=File;Initial Catalog=|My Documents|\MyDB;User=myUsername;
    Password
    =myPassword;
Problems connecting?
Get answer in the EffiProz Q & A forum

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.