读书人

[]怎样写数据库连接字符串

发布时间: 2012-02-20 21:18:24 作者: rapoo

[求助]怎样写数据库连接字符串
大牛们,给个范例吧~~

[解决办法]
连接SQLServer的例子:

C/C++ code
void __fastcall TForm1::Button1Click(TObject *Sender){    String strDbSvr = "127.0.0.1";    String strDbUsr = "用户名";    String strDbPwd = "密码";    String strDbName = "数据库名";    ADOConnection1->Connected = false;    ADOConnection1->ConnectionString = String().sprintf(            TEXT("Provider=SQLOLEDB.1;")            TEXT("Persist Security Info=True;")            TEXT("Data Source=%s;")            TEXT("User ID=%s;")            TEXT("Password=%s;")            TEXT("Initial Catalog=%s"),            strDbSvr, strDbUsr, strDbPwd, strDbPwd);    bool bSuccess = true;    try    {        ADOConnection1->Connected = true;    }    catch(...)    {        bSuccess = false;    }    ShowMessage(bSuccess? "连接成功.": "连接失败!");} 

读书人网 >C++ Builder

热点推荐