VistaDB connection strings
VistaDB ADO.NET Provider
-
Standard
Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;
-
Read only connection
Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadOnly;
-
Shared access
Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=NonExclusiveReadWrite;
-
Shared access, connection read only
Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=NonExclusiveReadOnly;
-
-
Shared access, database read only
Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=SharedReadOnly;
-
Connection Pooling
Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;
Pooling=True;Min Pool Size=10;Max Pool Size=30; -
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; -
Turn off transactions
Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;
Transaction Mode=off; -
Ignore transactions
Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;
Transaction Mode=ignore;
↯ Problems connecting?
Get answer in the VistaDB Q & A forum
Connect
Articlesread all »
- Formating Rules for Connection Strings
- Connection Strings Explained
- Store Connection String in Web.config
- Connection Pooling
- The Provider Keyword, ProgID, Versioning and COM CLSID Explained
- SQL Server Data Types Reference
- Network Protocol for SQL Server Connection
- All SQL Server SqlConnection Properties
- When to use the SQL Native Client
- Open a password-protected Excel workbook
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.
This single process read write is the fastest access mode.