Question

delphi中用ADO远程访问局域网数据库怎么配客户端sql2000

Answer 1

apassword //登陆服务器：密码参数
aopername //登陆服务器：用户参数

asqlserver//登陆服务器：名称或者IP参数
asqldb //登陆服务器: 数据库名称参数

dm.Adoconn.Connected:=False;
connstr:='Provider=SQLOLEDB.1;Password='+apassword
+'; Persist Security Info=False;'+
'User ID='+aopername
+';Initial Catalog='+asqldb
+';Data Source='+asqlserver+'; Use Procedure for Prepare=1;'+
'Auto Translate=True;Packet Size=4096;Workstation'+
' ID='+asqlserver
+';1Use Encryption for Data=False;Tag'+
' with column collation when possible=False';

dm.adoconn.ConnectionString:=connstr;
dm.Adoconn.Connected:=true;

Answer 2

你是想问怎样配置adocon吗?

with ADOConnection do
begin
Connected:= false;
Provider:= 'SQLOLEDB.1';
Properties['Data Source'].Value:= sql_db; //sql服务器名或IP
Properties['Initial Catalog'].Value:= test; //表名
Properties['User ID'].Value:= sa; //sql用户名
Properties['password'].Value:= 12345; //密码
LoginPrompt:= false;
Connected:= true;
end;