ado 连接sql server数据库

1. 连接字符串：

//本地链接sql server 2008

connectStr="Provider=SQLOLEDB;Password=XXX;Persist Security Info=True;User ID=sa;Initial Catalog=DATABASE;Data Source=."

//本地链接sql server 2005

connectStr="Provider=SQLNCLI.1;Password=XXX;Persist Security Info=True;User ID=sa;Initial Catalog=Database;Data Source=."

//远程链接sql server 2005(sql server 同时要设置远程访问)

connectStr="Provider=SQLOLEDB;network library= DBMSSOCN;Data Source=219.223.252.170;Password=XXX;User ID=sa;Initial Catalog=Database;";

     2. 链接过程：

        _ConnectionPtr m_pConnection;

isComInited = ::CoInitialize(NULL); //初始化COM库

try

{

if( FAILED( m_pConnection.CreateInstance(__uuidof(Connection)) ) ) //创键Connection对象

{

printf("创建Connection对象出错");

}

else

{

m_pConnection->Open (strConnect,"","", adModeUnknown);

}

}

catch(...)

{

printf("链接数据库出错");

}