VistaDB connection strings

VistaDB ADO.NET Provider

  • Standard

    Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;

    This single process read write is the fastest access mode.

  • Read only connection

    Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadOnly;
  • Shared access

    Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=NonExclusiveReadWrite;

    Multiple processes can access the database and lock files may be generated.

  • Shared access, connection read only

    Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=NonExclusiveReadOnly;

    The connection is read only. However, the database is open for other connections and those other connections can have write access.

  • Shared access, database read only

    Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=SharedReadOnly;

    Multiple processes can access the database. All of them must be in read only mode. No lock files is generated.

  • Connection Pooling

    Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;
    Pooling
    =True;Min Pool Size=10;Max Pool Size=30;

    To disable pooling set Pooling=False; and remove the Min Pool Size and Max Pool Size from the connection string.

  • Database Encryption

    This is only for encryption. Not any type of user level access.

    Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;
    Password
    =myEncryptionKey;

    Spaces are not allowed and no ' or " characters.

    Important! If no encryption are used, do NOT specify at all in the connection string. A blank value like Password=; turns on encryption with a blank key. Leave the whole Password key out of the connection string.

  • Turn off transactions

    Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;
    Transaction Mode
    =off;

    If transactions is attempted by the client, an error will occur.

  • Ignore transactions

    Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;
    Transaction Mode
    =ignore;

    If the client starts a transaction, a transaction will not be created.

Problems connecting?
Get answer in the VistaDB 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.