VistaDB ADO.NET Provider connection strings

VistaDB

Standard

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

This single process read write is the fastest access mode.

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.