试试下面这个函数,它可以得到所有正在运行的SQL列表。返回值是SQL个数。 function SQLServerList(var ServerList:Tstrings):integer; var SQLServer:Variant; SvrList:Variant; i,nServers:integer; sRetValue:String; begin SQLServer := CreateOleObject('SQLDMO.Application'); SvrList:= SQLServer.ListAvailableSQLServers; nServers:=SvrList.Count; serverlist.Clear; for i := 1 to nservers do serverlist.Add(svrlist.Item(i)); SQLServer:=NULL; svrList:=NULL; result:=nServers; end;
你的连接控件.Connectioned := True;
已启动
except
没有启动
end;
function SQLServerList(var ServerList:Tstrings):integer;
var
SQLServer:Variant;
SvrList:Variant;
i,nServers:integer;
sRetValue:String;
begin
SQLServer := CreateOleObject('SQLDMO.Application');
SvrList:= SQLServer.ListAvailableSQLServers;
nServers:=SvrList.Count;
serverlist.Clear;
for i := 1 to nservers do
serverlist.Add(svrlist.Item(i));
SQLServer:=NULL;
svrList:=NULL;
result:=nServers;
end;