为什么我这样不行呀!
我用adoconnection连接sql7数据库.
按照上述方法使用adocommand.
procedure TForm1.Button2Click(Sender: TObject);
begin
adocommand1.Commandtext:='sp_attach_db aaa,'+#39+'c:/mssql7/data/rsglxt_data.mdf'+#39+','+#39+'c:/mssql7/data/rsglxt_log.ldf'+#39;
end;
程序执行没错但在sql7中没有建立数据库.
如果使用ADOStoredProc则出错:
cannot use empty object or column names,use a single space if necessary.
procedure TForm1.Button1Click(Sender: TObject);
begin
ADOStoredProc1.Parameters[1].Value:='aaa,';
ADOStoredProc1.Parameters[2].Value:=#39+'c:/mssql7/data/rsglxt_data.mdf'+#39+',';
ADOStoredProc1.Parameters[3].Value:=#39+'c:/mssql7/data/rsglxt_log.ldf'+#39;
ADOStoredProc1.Active:=true;
ADOstoredProc1.Prepared;
ADOStoredProc1.ExecProc;
end;
