RT
程式运行时,我想点击一个BUTTOM,改变目前已经连接的应用服务器。两台应用服务器分别连接不同的资料库
程式运行时,我想点击一个BUTTOM,改变目前已经连接的应用服务器。两台应用服务器分别连接不同的资料库
解决方案 »
- delphi7设置AA.BB.CC.dpr的OutputDir为D:\目录,得到AA.BB.Exe,.CC丢失了
- 一个F1book问题,懂的帮帮忙!!万分感谢……
- 第一次用Delphi7,怎么用报表实现一个小功能,求教!
- tongdings(痛定) 请进。
- 怎么发短消息?
- 请教高手:如何把一个类封装成DLL?以及其DLL在程序中的引用。谢谢!!
- 求助
- serversocket,clientsocket请看http://www.csdn.net/expert/Topic/123/123419.shtm
- 各位大虾,请近,大讨论
- 关于reportbuil报表控件的安装口令
- 天气冷了,给spring4d投个票活动一下
- paradox小程序
var
StrTemp:string;
i:integer;
begin
Bimage:=True;
tStage:='ASSY';
if not LoadApServer then begin
application.Terminate;
exit;
end;
with G_sockConnection do begin
ServerGUID:='{AF550BF4-3BA4-415D-B1F3-E2F7C8ADE30C}';
ServerName:='SajetApserver.RMDB';
end;
G_sockConnection.Connected:=false;
QryData.RemoteServer := G_sockConnection;
QryData.ProviderName := 'DspQryData';
QryTemp.RemoteServer := G_sockConnection;
QryTemp.ProviderName := 'DspQryTemp1';
QryTemp1.RemoteServer := G_sockConnection;
QryTemp1.ProviderName := 'DspQryTemp1';
QryTemp2.RemoteServer := G_sockConnection;
QryTemp2.ProviderName := 'DspQryTemp1';
SProc.RemoteServer := G_sockConnection;
SProc.ProviderName := 'DspStoreproc';end;
Var F : TextFile;
S : String;
begin
Result := False;
G_sockConnection.Connected := False;
SimpleObjectBroker1.Servers.Clear;
If not FileExists(GetCurrentDir+'\ApServer.cfg') Then begin
showmessage('No ApServer.cfg!');
Exit;
end;
AssignFile(F,GetCurrentDir+'\ApServer.cfg');
Reset(F);
While True do
begin
Readln(F, S);
If S <> '' Then
begin
SimpleObjectBroker1.Servers.Add;
SimpleObjectBroker1.Servers[SimpleObjectBroker1.Servers.Count-1].ComputerName := Trim(S);
SimpleObjectBroker1.Servers[SimpleObjectBroker1.Servers.Count-1].Enabled := True;
end Else
Break;
end;
CloseFile(F);
Result := True;
end;
1、关闭TADOConnection
DataModule1.ADOCon.Connected:=False;
2、设置ConnectionString值
ConnectionString:='Provider=SQLOLEDB.1;'+
'Password='+Password+';'+
'Persist Security Info=True;'+
'User ID='+UserName+';'+
'Initial Catalog='+DatabaseName+';'+
'Data Source='+ServerName;
3、重新连接
try
DataModule1.ADOCon.Connected:=False;
DataModule1.ADOCon.ConnectionString:=ConnectionString;
DataModule1.ADOCon.Connected:=True;
StatusBar1.Panels[0].Text:=' 连接成功!';
except
StatusBar1.Panels[0].Text:=' 连接失败!';
end;