【ASP.NET】DB連線字串參考

連接 SQL Server

方式一:
.NET Framework Data Provider for SQL Server
Type: .NET Framework Class Library
Usage: System.Data.SqlClient.SqlConnection
Manufacturer: Microsoft

Ex1:
Data Source=192.168.0.1;Initial Catalog=testDB;User Id=sa;Password=12345;

Ex2:
Server=192.168.0.1;Database=testDB;User ID=sa;Password=12345;Trusted_Connection=False;

方式二(SQL Server 2008 Express):
SQL Server Native Client 10.0 OLE DB Provider
Type: OLE DB Provider
Usage: Provider=SQLNCLI10
Manufacturer: Microsoft

Ex:
Provider=SQLNCLI10;Server=192.168.0.1;Database=testDB;Uid=sa; Pwd=12345;

------------------------------------------------------------------------------------------------
連接 Access

方式一(*.accdb):
ACE OLEDB 12.0
Type: OLE DB Provider
Usage: Provider=Microsoft.ACE.OLEDB.12.0
Manufacturer: Microsoft

Ex:
Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\db\myAccess.accdb;Persist Security Info=False;

方式二(*.mdb, *.accdb):
Microsoft Access accdb ODBC Driver
Type: ODBC Driver
Usage: Driver={Microsoft Access Driver (*.mdb, *.accdb}
Manufacturer: Microsoft

Ex:
Driver={Microsoft Access Driver (*.mdb, *.accdb)};
Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;

===================================================================================
更多相關的連接方式 請參閱下面網址
http://www.connectionstrings.com/