数据库连接之一:Access数据库连接字符串
Microsoft Jet OLE DB 4.0
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=;
.NET Framework Data Provider for OLE DB
Bridging to Jet OLE DB 4.0:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
Microsoft Access ODBC Driver
Standard Security:
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
Workgroup:
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;
Exclusive:
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd=;
Enable admin statements:
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;ExtendedAnsiSQL=1;
Specifying locale identifier:
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Locale Identifier=2057;Uid=Admin;Pwd=;
.NET Framework Data Provider for ODBC
Bridging to Microsoft Access ODBC Driver
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
ADO数据库连接中的Persist Security Info参数的作用
ADO用了这么久，每次用向导创建ADO的数据库连接字符串时总会有产生一个Persist Security Info属性，平时没太注意，因为设置为True或False时对数据库连接没有任何影响。不过心理还是不爽，今天有时间查询了一下资料，总算搞清楚了它的作用。
Persist Security Info属性的意思是表示是否保存安全信息，其实可以简单的理解为"
相关文档：
在SQL Server 内查询Access 数据, 并将数据保存到SQL Server
'Jet OLEDB:Database Password=; /*Access 密码*/
Data Source=C:\temp\Test.mdb; /*Access 数据库路径*/
Password=;/*Access工作组密码*/
1. 查询Access 表内所有数据
SELECT *
from OPENDATASOURCE
('Microsoft.Jet.OLEDB.4.0',
'Jet OLEDB:Database ......
access中case替代方法
2009-12-26 14:01
SELECT
UserPassportID as PassportID,
UserID,
GrantorID,
Case ObjectTypeID
When 1 then ObjectID
End
as TerminalID,
Type, Flag, GrantDate, Validate, Invalidate
from UserPassport
在SQL里能执行,但在Access里总提示语法错误(操作符丢失).在查询表达式'Case O ......
问题：目前还没有64位的Jet oledb provider
(不知以后有否)，在64位系统上调用Jet oledb provider时会遇到如下错误：
"The
'Microsoft.jet.OLEDB.4.0' provider is not registered on the local machine.
"
解决：32位的Jet oledb provider是存在的，那么可以利用IIS的32 Mode特性，将web程序运行在32位模式 ......
Store an Image(OLE Object) into Access Data Base
C# Winform application Store an Image into Access Data Base
用以下方法
/// 2010-02-26 Forever
private void SaveImageInDataBase()
{
& ......
