数据库连接字符串 - Microsoft Access
ODBC DSN
// ODBC DSN
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = "Dsn=DsnName"; conn.Open(); |
ODBC -- Standard Security
// ODBC -- Standard Security
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" + "Dbq=c:/myPath/myDb.mdb;" + "Uid=Admin;Pwd=;"; conn.Open(); |
ODBC -- Workgroup (System Database)
// ODBC -- Workgroup (System Database)
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" + "Dbq=c:/myPath/myDb.mdb;" + "SystemDb=c:/myPath/myDb.mdw;"; conn.Open(); |
ODBC -- Exclusive Use
// ODBC -- Exclusive Use
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" + "Dbq=c:/myPath/myDb.mdb;" + "Exclusive=1;"; "Uid=Admin;Pwd=;"; conn.Open(); |
OleDb with MS Jet -- Standard Security
// OleDb with MS Jet -- Standard Security
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=c:/mypath/myDb.mdb;" + "User id=admin;" + "Password="; conn.Open(); |
OleDb with MS Jet -- Workgroup (System Database)
// OleDb with MS Jet -- Workgroup (System Database)
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=c:/mypath/myDb.mdb;" + "System Database=c:/mypath/myDb.mdw;"; conn.Open(); |
OleDb with MS Jet -- With Password
// OleDb with MS Jet -- With Password
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=c:/mypath/myDb.mdb;" + "Database Password=Secret;" conn.Open(); |