如何使用ADOConnection中的ConnectionString?

krakan 2004-09-02 09:30:17

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

...全文

248 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

3996906 2004-09-02

打赏
举报

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

futulove 2004-09-02

打赏
举报

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

heguxun 2004-09-02

打赏
举报

老大,应该是这样的:
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 2004-09-02

打赏
举报

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

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

krakan 2004-09-02

打赏
举报

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;
}
那为什么这段程序不行呢？

3996906 2004-09-02

打赏
举报

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

lifuming 2004-09-02

打赏
举报

//下面是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);
};