資料庫連接字串 – Microsoft Access

資料庫連接字串 - 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();