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.

  • VistaDB

• Read only connection

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

• Shared access

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

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

  • VistaDB

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

  • VistaDB

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

  • VistaDB

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

  • VistaDB

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

  • VistaDB

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

  • VistaDB

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

  • VistaDB