(1)OLEDB
Windows 身份验证
"Provider=SQLOLEDB;Data Source=PEK7-6TKX23X\SQLEXPRESS;Initial Catalog=Test;Trusted_Connection=Yes;";
SQL Server 身份验证
"Provider=SQLOLEDB;Data Source=127.0.0.1\SQLEXPRESS;Initial Catalog=Test;User Id=sa;Password=123456;";
(2)SqlConnection
Windows 身份验证
"Data Source=PEK7-6TKX23X\SQLEXPRESS;Initial Catalog=Test;Trusted_Connection=Yes;";
SQL Server 身份验证
"server=127.0.0.1\SQLEXPRESS;database=Test;Uid=sa;PassWord=123456";
(3)ODBC
Driver={SQL Server}; Server=服务器IP; Database=数据库名; Uid=用户名; Pwd=密码;
(4)DSN方式
DSN=DSN名; Uid=用户名; Pwd=密码;
Windows 身份验证
"Provider=SQLOLEDB;Data Source=PEK7-6TKX23X\SQLEXPRESS;Initial Catalog=Test;Trusted_Connection=Yes;";
SQL Server 身份验证
"Provider=SQLOLEDB;Data Source=127.0.0.1\SQLEXPRESS;Initial Catalog=Test;User Id=sa;Password=123456;";
(2)SqlConnection
Windows 身份验证
"Data Source=PEK7-6TKX23X\SQLEXPRESS;Initial Catalog=Test;Trusted_Connection=Yes;";
SQL Server 身份验证
"server=127.0.0.1\SQLEXPRESS;database=Test;Uid=sa;PassWord=123456";
(3)ODBC
Driver={SQL Server}; Server=服务器IP; Database=数据库名; Uid=用户名; Pwd=密码;
(4)DSN方式
DSN=DSN名; Uid=用户名; Pwd=密码;