Connect VC ++ to the SQL Server database (Remote + local)

Connect to the remote database sqlserver2005
Cstring strconn =_ T ("driver = {SQL Server}; server = 192.168.57.49, 1433; database = data name; uid = user name; Pwd = password "); (Driver = {SQL native client} is a string connecting to the local database. An error occurs when connecting to the remote database)
Connect to local database
Sqlserver2005
Cstring strconnserver2005 = _ T ("provider = sqloledb.1; persist Security info = false; initial catalog = databasename; Data Source = 127.0.0.1 ");
Sqlserver2008
Cstring strconnserver2008 = _ T ("provider = sqloledb.1; Integrated Security = sspi; persist Security info = false; initial catalog = databasename; Data Source =. \ Sqlexpress; User id = username; Password = password ;");
Pass the test (. \ Sqlexpress escape \ depends on the situation, because it is placed in the string, so you need )
 M_pconnection-> open (_ bstr_t (strconn), _ bstr_t (struserid), _ bstr_t (strpassword), admodeunknown );