Connection strings for Access (Part 2): Справочник по C#

Microsoft Jet OLE DB 4.0

Тип: OLE DB Provider
Использование: Provider=Microsoft.Jet.OLEDB.4.0
Производитель: Microsoft

Standard Security

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:mydatabase.mdb;User Id=admin;Password=;

With database password

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;

Workgroup (system database)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:mydatabase.mdb;Jet OLEDB:System Database=system.mdw;

Workgroup (system database) specifying username and password

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:mydatabase.mdb;Jet OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword;

DataDirectory functionality

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|myDatabase.mdb;User Id=admin;Password=;

Network Location

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\serverNameshareNamefoldermyDatabase.mdb;User Id=admin;Password=;

Using RDS (MS Remote)

Provider=MS Remote;Remote Provider=Microsoft.Jet.OLEDB.4.0;Remote Server=http://server.adress.com;Data Source=d:myPathmyDatabase.mdf;

Exclusive

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:mydatabase.mdb;Mode=Share Exclusive;User Id=admin;Password=;

0.00 (0%) 0 votes