关于oracle dblink的问题?
adocommand1先是与一个Oracle服务器建立连接然后执行
with adocommand1 do
begin
commandtext:='';
commandtext:='create database link hbwnps connect to hbwnps identified by wnps_6610 using '+#39+'HBZJK'+#39;
execute;
end;//已通过对另一个Oracle服务器连接
然后执行
procedure TForm1.Button2Click(Sender: TObject);
begin
with adoquery1 do//adoquery1与adocommand1连接的服务器一样
begin
close;
sql.Clear;
sql.Add('select * from t_xm_pubinfo@hbwnps');
open;
end;
end;
报'ora-12154:tns无法处理服务名'