DELPHI没用过
调用oracle的exp与imp吧,用批处理文件不错
调用oracle的exp与imp吧,用批处理文件不错
解决方案 »
- 急!Oracle 10g安装问题,HP UNIX11.31,苏州有谁可上门装
- 一个Oracle问题
- oracle 调用 DLL里面的方法,不出错,但没效果
- Error 数��供方内部错误(-3001)
- linux中如何实现访问oracle的pro*c/c++接口封装
- 有法自己让oracle 产生一个表描述吗?
- 怎么用sql语句查看视图的创建语句?
- oracle 10g 触发器
- 模糊查询 表A中有一些记录如 "12??5" ,"1?3?5",“?23?5","?2???" ,寻查询的SQL语句!
- oracle语句未正确结束
- 请教哪里有Oracle9下载!
- 大家帮我看看这过创建存储过程的语句错在那里?
http://expert.csdn.net/Expert/topic/2042/2042629.xml?temp=.4393885
procedure TForm1.Button1Click(Sender: TObject);
begin
if SaveDialog1.Execute then
begin
try
adoconnection1.Connected:=False;
adoconnection1.ConnectionString:='Provider=SQLOLEDB.1;Persist Security
Info=False;User ID=sa;Initial Catalog=master;Data Source=FRIEND-YOFZKSCO;'+
'Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Works
tation ID=FRIEND-YOFZKSCO;Use Encryption for Data=False;Tag
with column collation when possible=False';
adoconnection1.Connected:=True; with adoQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Backup DataBase sfa to disk ='''+Savedialog1.FileName+'''');
ExecSQL;
end;
except
ShowMessage('±?·Y꧰ü');
Exit;
end;
end;
Application.MessageBox('1§?2?ú£?êy?Y±?·Y3é1|','ìáê?',MB_OK +
MB_ICONINFORMATION);
end;恢复:
procedure TForm1.Button2Click(Sender: TObject);
begin
if OpenDialog1.Execute then
begin
try
adoconnection1.Connected:=false;
adoconnection1.ConnectionString:='Provider=SQLOLEDB.1;Persist Security
Info=False;User ID=sa;Initial Catalog=master;Data Source=FRIEND-
YOFZKSCO;'+'Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=FRIEND-YOFZKSCO;Use Encryption for
Data=False;Tag with column collation when possible=False';
adoconnection1.Connected:=true; with adoQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Restore DataBase sfa from disk='''+opendialog1.FileName+''' ');
ExecSQL;
end;
except
ShowMessage('???′꧰ü');
Exit;
end;
end;
Application.MessageBox('1§?2?ú£?êy?Y???′3é1|','ìáê?',MB_OK +
MB_ICONINFORMATION);
end;