数据库连接配置大全-优快云博客

本文汇总了多种数据库（包括Access和Oracle）通过不同技术（如ODBC、OLEDB等）进行连接时所需的配置字符串示例。这些示例覆盖了标准安全、工作组及独占等多种连接方式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ACCESS
ODBC
标准安全	"Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:/mydatabase.mdb; Uid=Admin; Pwd=; "
工作组	"Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:/mydatabase.mdb; SystemDB=C:/mydatabase.mdw; "
独占	"Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:/mydatabase.mdb; Exclusive=1; Uid=admin; Pwd="
OLE DB, OleDbConnection (.NET)
标准安全	"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/somepath/mydb.mdb; User Id=admin; Password=; "
工作组 (system database)	"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/somepath/mydb.mdb; Jet OLEDB:System Database=system.mdw; "
使用密码	"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/somepath/mydb.mdb; Jet OLEDB:Database Password=MyDbPassword; "

Oracle
ODBC
新版本	"Driver={Microsoft ODBC for Oracle}; Server=OracleServer.world; Uid=Username; Pwd=asdasd; "
旧版本	"Driver={Microsoft ODBC Driver for Oracle}; ConnectString=OracleServer.world; Uid=myUsername; Pwd=myPassword; "
OLE DB, OleDbConnection (.NET)
标准安全	"Provider=msdaora; Data Source=MyOracleDB; User Id=UserName; Password=asdasd; " This one's from Microsoft, the following are from Oracle
标准安全	"Provider=OraOLEDB.Oracle; Data Source=MyOracleDB; User Id=Username; Password=asdasd; "
信任的连接	"Provider=OraOLEDB.Oracle; Data Source=MyOracleDB; OSAuthent=1; "
OracleConnection (.NET)
标准	"Data Source=MyOracleDB; Integrated Security=yes; " This one works only with Oracle 8i release 3 or later
指定用户名和密码	"Data Source=MyOracleDB; User Id=username; Password=passwd; Integrated Security=no; " This one works only with Oracle 8i release 3 or later
定义OracleConnection对象	C#: using System.Data.OracleClient; OracleConnection oOracleConn = new OracleConnection(); oOracleConn.ConnectionString = "my connection string"; oOracleConn.Open();
定义OracleConnection对象	VB.NET: Imports System.Data.OracleClient Dim oOracleConn As OracleConnection = New OracleConnection() oOracleConn.ConnectionString = "my connection string" oOracleConn.Open()
Core Labs OraDirect (.NET)
标准	"User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"
Data Shape
微软数据模型	"Provider=MSDataShape.1; Persist Security Info=False; Data Provider=MSDAORA; Data Source=orac; user id=username; password=mypw"

数据库连接字符串大全