- ODBC DSN
- ODBC -- Standard Security
- ODBC -- Workgroup (System Database)
- ODBC -- Exclusive Use
- OleDb with MS Jet -- Standard Security
- OleDb with MS Jet -- Workgroup (System Database)
- OleDb with MS Jet -- With Password
-
-
- using System.Data.Odbc;
-
- OdbcConnection conn = new OdbcConnection();
- conn.ConnectionString = "Dsn=DsnName";
- conn.Open();
-
-
- 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();
-
-
- 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();
-
-
- 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();
-
-
- 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();
-
-
- 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();
-
-
- 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();