MS Access connection strings
来源:互联网 发布:学方言的软件 编辑:程序博客网 时间:2024/05/22 12:43
MS Access ODBC connection strings
Standard Security:
"Driver= {MicrosoftAccessDriver(*.mdb)};DBQ=C:/App1/Your_Database_Name.mdb;Uid=Your_Username;Pwd=Your_Password;"
Workgroup:
"Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:/App1/Your_Database_Name.mdb; SystemDB=C:/App1/Your_Database_Name.mdw;"
Exclusive "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:/App1/Your_Database_Name.mdb; Exclusive=1; Uid=Your_Username; Pwd=Your_Password;"
MS Access OLE DB & OleDbConnection (.NET framework) connection strings
Open connection to Access database:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/App1/Your_Database_Name.mdb; User Id=admin; Password="
Open connection to Access database using Workgroup (System database):
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/App1/Your_Database_Name.mdb; Jet OLEDB:System Database=c:/App1/Your_System_Database_Name.mdw"
Open connection to password protected Access database:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/App1/Your_Database_Name.mdb; Jet OLEDB:Database Password=Your_Password"
Open connection to Access database located on a network share:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=//Server_Name/Share_Name/Share_Path/Your_Database_Name.mdb"
Open connection to Access database located on a remote server:
"Provider=MS Remote; Remote Server=http://Your-Remote-Server-IP; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/App1/Your_Database_Name.mdb"
- MS Access connection strings
- mssql、mysql、access、Oracle connection strings
- MS Access
- access connection
- ADO Connection Strings
- ADO Connection Strings
- ADO connection strings List
- SQL Server connection strings
- MySQL connection strings
- Oracle connection strings
- ADO Connection Strings
- ORACLE connection strings reference
- Npgsql connection strings
- MS Access 最大属性
- MS Access数据库连接
- Connection strings for all driver
- Connection strings for Oracle zz
- Connection strings for Excel 2007
- 一如既往
- 2009.12.14笔记
- .cn域名的那点事儿
- 在 Domino 系统中如何路由邮件
- C++入门者可能的读书计划
- MS Access connection strings
- SQL Server connection strings
- MySQL connection strings
- >个人主义<
- Oracle connection strings
- dssdfsdfsdfsdfsdfsdf
- 网吧母盘常用批处理
- sql 查询先进先出
- 猜数字——Python版