配置数据库连接字符串

最新推荐文章于 2023-07-16 22:09:36 发布

转载最新推荐文章于 2023-07-16 22:09:36 发布 · 243 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/mingle/archive/2010/01/28/adonet-connectionstring.html

文章标签：

#人工智能 #数据库

【翻译】http://www.connectionstrings.com/sql-server-2008#p20

MS SQL Server 2008

Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

Code Example:

string connectionString = null;
connectionString = "Provider=SQLOLEDB;Server=MINGLE;Database=Northwind;Uid=sa;Pwd=123456";
OleDbConnection cnn = new OleDbConnection(connectionString);
try
{
    cnn.Open();
    Response.Write("Connection Open ! ");
    cnn.Close();
}
catch (Exception ex)
{
   Response.Write("Can not open connection ! ");
}