VC链接sqlserver字符串

_bstr_t strConnect = "Provider=SQLOLEDB.1;\
Server=WISESVR;\
DATABASE=Test;\
UID=sa;\
PWD=;";


//是针对数据库身份验证模式为”SQL SERVER 和 windows“
strConnect = "Provider = SQLOLEDB.1;\
Persist Security Info = true;\
User ID = sa;\
Password=;\
Initial Catalog = Test;\
Data Source = 192.168.1.50";

//身份验证模式为“仅 windows”
strConnect ="Provider = SQLOLEDB.1;\
Integrated Security=SSPI;\
Persist Security Info =false;\
Initial Catalog = Test;\
Data Source = 192.168.1.50;";


//仅针对ODBC的连接方式
strConnect = "Provider = SQLOLEDB;\
Server = 192.168.1.50;\
DATABASE=Test;\
User ID=sa;\

password=;";

                                    User ID 可以写为UID或uid

                                    Password可以写为 PWD或pwd

                                    Server后等号两边不可以留空格（不知道为什么？）