Question

C++ 读取ini文件动态链接数据库

config.ini 文件内容为：
[SYSTEM]
REMOTE=192.168.1.11
DB=Patrol
USER=sa
PWD=sa
获取这个文件的值的代码：
CString remote,db,user,pass;
GetPrivateProfileString("SYSTEM","REMOTE","",remote.GetBuffer(MAX_PATH),MAX_PATH,"..\\config.ini");
GetPrivateProfileString("SYSTEM","DB","",db.GetBuffer(MAX_PATH),MAX_PATH,"..\\config.ini");
GetPrivateProfileString("SYSTEM","USER","",user.GetBuffer(MAX_PATH),MAX_PATH,"..\\config.ini");
GetPrivateProfileString("SYSTEM","PWD","",pass.GetBuffer(MAX_PATH),MAX_PATH,"..\\config.ini");
把获取到的 remote，db，user，pass
赋值给：
_bstr_t strConnect = "Provider=SQLOLEDB; Server="+remote+";Database="+db+"; uid="+user+"; pwd="+pass+";";
但是链接数据库出错 报错：
用户'(null)'登陆失败
有知道是什么原因吗

Answer 1

_bstr_t strConnect = "Provider=SQLOLEDB; Server="+remote+";Database="+db+"; uid="+user+"; pwd="+pass+";";

建议先在外面使用Cstring strTemp;去格式化连接字符串
如strTemp.Format(_T("Provider=SQLOLEDB; Server=%s;Database=%s; uid=%s; pwd=%s"),remote,db,user,pass);