ASP.NET中C#的数据库连接字符串

来源：互联网发布：猪八戒刷淘宝流量编辑：程序博客网时间：2024/04/28 08:28

OleDB数据库连接字符串
access
"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=F:/db1.mdb"

sqlserver:
"Provider=SQLOLEDB;User ID=sa;Initial Catalog=Northwind;password=;datasource=localhost"

Oracle:
"Provider=MSDAORA;User ID=scott;password=tiger;Data Source="
对于Oracle来说,Data Source含义是本地的网络服务名
ADO.NET连接Oracle数据库一定需要oracle的客户端

MS text :
"Provider=microsof.jet.oledb.4.0;data source=your_path;Extended Properties'text;FMT=Delimited'"

ODBC连接字符串

适合数据库类型连接方式
access   "Driver={microsoft access driver(*.mdb)};dbq=*.mdb;uid=admin;pwd=pass;"

dBase   "Driver={microsoft dbase driver(*.dbf)};driverid=277;dbq=------------;"

oracle   "Driver={microsoft odbc for oracle};server=oraclesever.world;uid=admin;pwd=pass;"

MSSQL server   "Driver={sql server};server=servername;database=dbname;uid=sa;pwd=pass;"

MS text   "Driver={microsoft text driver(*.txt; *.csv)};dbq=-----;extensions=asc,csv,tab,txt;Persist SecurityInfo=false;"

Visual Foxpro   "Driver={microsoft Visual Foxpro driver};sourcetype=DBC;sourceDB=*.dbc;Exclusive=No;"

MySQL   "Driver={mysql};database=yourdatabase;uid=username;pwd=yourpassword;option=16386;"

查看全部的数据库连接字符串：
http://www.connectionstrings.com/