[求助]怎样写数据库连接字符串
大牛们,给个范例吧~~
[解决办法]
连接SQLServer的例子:
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? "连接成功.": "连接失败!");}