如何使用ADOConnection中的ConnectionString?

[krakan]

我现在想从交互界面中提取信息配置ConnectionString，可我不知道ConnectionString书写的格式。

[lifuming]

//下面是ACCESS连接设置
connectSQL="Provider=Microsoft.Jet.OLEDB.4.0;";
connectSQL=connectSQL+"Data Source="+FileName+";"; /*ExtractFilePath(Application->ExeName)+"\\gsdatabase.mdb;";*/
connectSQL=connectSQL+"Persist Security Info=False;";
connectSQL=connectSQL+"User ID=Admin;Jet OLEDB:Database Password=SUPER";

tranConnect->Connected=false;
tranConnect->ConnectionString=connectSQL;

try{
tranConnect->Connected=true;
flag=true;
}catch(...){
MessageBox(NULL,"Document Base initialize failed！","Error...",MB_ICONERROR);
};

[3996906]

CONNSTR=Provider=SQLOLEDB.1;Password=sa1;Persist Security Info=True;User ID=sa1;Initial Catalog=databasename;Data Source=192.168.1.3

[krakan]

void __fastcall TForm1::Button1Click(TObject *Sender)
{
ADOConnection1->ConnectionString ="Provider=SQLOLEDB.1;Password=pas->Text;Persist Security Info=True;User ID=user->Text;Initial Catalog=database->Text;Data Source=address->Text";
ADOTable1->Active = true;
ADOTable1->TableName=Edit1->Text;
}
那为什么这段程序不行呢？

[liangzhanru]

Password=pas->Text;Persist Security Info=True;User ID=user->Text;Initial Catalog=database->Text;Data Source=address->Text

是错误的,具体的办法你去看下<<C++BUILDER系统开发>>的第五章!!!!!

[heguxun]

老大,应该是这样的:
void __fastcall TForm1::Button1Click(TObject *Sender)
{
ADOConnection1->ConnectionString ="Provider=SQLOLEDB.1;Password=" + pas->Text+";Persist Security Info=True;User ID="+user->Text+";Initial Catalog="+database->Text+";Data Source="+address->Text+";";
ADOTable1->Active = true;
ADOTable1->TableName=Edit1->Text;
}
变量不能用引号括起来,用引号括起来就是字符串了

[futulove]

你先在设计程序的时候连接一下子把字符串考出来看一下不就知道了吗

[3996906]

按 heguxun(低级程序员) 说的,字符串组合一下,要还不行把你的->Text弄成->Text.c_str()