如果DELPHI程序要运行在机器名为A的电脑上,而所要访问的数据库则是在电脑B上,需要通过修改IP地址实现访问,请问ADOCONNECTIN中该怎么修改? 原来的如下:
Provider=SQLOLEDB.1;Password="";Persist Security Info=True;User ID=sa;Initial Catalog=DL;Data Source='server';Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MAZW;Use Encryption for Data=False;Tag with column collation when possible=False';
Provider=SQLOLEDB.1;Password="";Persist Security Info=True;User ID=sa;Initial Catalog=DL;Data Source='server';Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MAZW;Use Encryption for Data=False;Tag with column collation when possible=False';
resourcestring
s1='Provider=SQLOLEDB.1;Password=';//touch1
s2='User ID=';//touch1
s3='Initial Catalog=';//hwyy
s4='Data Source=';//XYRMYY-SERVER
var
f:textfile;
a,b,c,d:string;
da:string;
begin
assignfile(f,getcurrentdir()+'\text\mzcf');
reset(f);
readln(f,a);
readln(f,b);
readln(f,c);
readln(f,d);
closefile(f);
form1.ADOConnection1.Close;
form1.ADOConnection1.ConnectionString:=s1+a+';'+s2+b+';'+s3+c+';'+s4+d+';';
form1.ADOConnection1.Open;