数据库连接字符串 - Microsoft SQL Server

来源：互联网发布：快速画流程图软件编辑：程序博客网时间：2024/05/10 00:39

ODBC DSN

// ODBC DSN

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();

conn.ConnectionString =

"Dsn=DsnName;" +

"Uid=UserName;" +

"Pwd=Secret;";

conn.Open();

ODBC -- Standard Connection

// ODBC -- Standard Connection

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();

conn.ConnectionString =

"Driver={SQL Server};" +

"Server=ServerName;" +

"DataBase=DataBaseName;" +

"Uid=UserName;" +

"Pwd=Secret;";

conn.Open();

ODBC -- Trusted Connection

// ODBC -- Trusted Connection

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();

conn.ConnectionString =

"Driver={SQL Server};" +

"Server=ServerName;" +

"DataBase=DataBaseName;" +

"Uid=;" +

"Pwd=;";

conn.Open();

// or

OdbcConnection conn = new OdbcConnection();

conn.ConnectionString =

"Driver={SQL Server};" +

"Server=ServerName;" +

"DataBase=DataBaseName;" +

"Trusted_Connection=Yes;";

conn.Open();

OleDb -- Standard Connection

// OleDb -- Standard Connection

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString =

"Driver=SQLOLEDB;" +

"Data Source=ServerName;" +

"Initial Catalog=DataBaseName;" +

"User id=UserName;" +

"Password=Secret;";

conn.Open();

OleDb -- Trusted Connection

// OleDb -- Trusted Connection

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString =

"Driver=SQLOLEDB;" +

"Data Source=ServerName;" +

"Initial Catalog=DataBaseName;" +

"Integrated Security=SSPI;";

conn.Open();

OleDb -- via IP Address

// OleDb -- via IP Address

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString =

"Driver=SQLOLEDB;" +

"Network Library=DBMSSOCN;" +

"Data Source=xxx.xxx.xxx.xxx,1433;" +

"Initial Catalog=DataBaseName;" +

"User id=UserName;" +

"Password=Secret;";

conn.Open();

.NET DataProvider -- Standard Connection

// .NET DataProvider -- Standard Connection

using System.Data.SqlClient;

SqlConnection conn = new SqlDbConnection();

conn.ConnectionString =

"Data Source=ServerName;" +

"Initial Catalog=DataBaseName;" +

"User id=UserName;" +

"Password=Secret;";

conn.Open();

.NET DataProvider -- Trusted Connection

// .NET DataProvider -- Trusted Connection

using System.Data.SqlClient;

SqlConnection conn = new SqlConnection();

conn.ConnectionString =

"Data Source=ServerName;" +

"Initial Catalog=DataBaseName;" +

"Integrated Security=SSPI;";

conn.Open();

.NET DataProvider -- via IP Address

// .NET DataProvider -- via IP Address

using System.Data.SqlClient;

SqlConnection conn = new SqlConnection();

conn.ConnectionString =

"Network Library=DBMSSOCN;" +

"Data Source=xxx.xxx.xxx.xxx,1433;" +

"Initial Catalog=DataBaseName;" +

"User id=UserName;" +

"Password=Secret;";

conn.Open();