如何在程序中用代码连接ms server 呢?
谢谢!
最好给我一段代码看看!
谢谢!
最好给我一段代码看看!
解决方案 »
- 如何在Delphi中编程获取内存的类型是什么(如DDR、DDR2)?
- 如何配置,可以连接到数据,进行grid读表操作
- 在 ExpressQuantumGrid 如何根据每行的内容 改变行的颜色 ????????
- [200分相送]帮忙解决Socket通讯报错的问题。急!!!
- 老问题,给没有Canvas的控件加Canvas,100分
- 请问如何将dbgrid和datetimepicker控件关联起来?
- 急救我!!!送分
- anywhere的表中,有一个时间字段sj,求时间字段的秒值为‘06’的SQL语句的条件表达式怎么写
- 一个sql语法的问题!急盼各位高手回音!
- delphi2010 多线程 post
- 如何象netants 那样可以接受拖过来的链接
- win98 下,怎么用Adoconnection连接 sql server2000数据库(个人版本)?
用ADOConnection,对ConnectionString进行动态指定服器的属性
如:ADOConnection.ConnectionString:='Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=数据库名;Data Source=YONG';
仅供参考!!!!!!!
function ConnectDB(DataBase:TDatabase;ServerName,UserName,PassWord:string;
DBName:string='master'):Boolean;
begin
Result:=false;
DataBase.Connected:=false;
DataBase.Params.Clear;
Database.DriverName:='MSSQL';
Database.Params.Values['DataBase Name']:=DBName;
Database.Params.Values['Server Name']:=ServerName;
Database.Params.Values['User Name']:=UserName;
Database.Params.Values['PassWord']:=Password;
try
Database.Connected:=true;
except
Exit;
end;
Result:=true;
end;
function ConnectDB(DataBase:TDatabase;ServerName,UserName,PassWord:string;
DBName:string='master'):Boolean;
begin
Result:=false;
DataBase.Connected:=false;
DataBase.Params.Clear;
Database.DriverName:='MSSQL';
Database.Params.Values['DataBase Name']:=DBName;
Database.Params.Values['Server Name']:=ServerName;
Database.Params.Values['User Name']:=UserName;
Database.Params.Values['PassWord']:=Password;
try
Database.Connected:=true;
except
Exit;
end;
Result:=true;
end;
var
mName,DatabaseName,uName,uPwd:String;
begin
mName:=ReadSetting(RegSession,'ServerName','Server');
DatabaseName:=ReadSetting(RegSession,'DataBaseName','Database');
uName:=ReadSetting(RegSession,'UserName','UserName');
uPwd:=ReadSetting(RegSession,'Password','Password'); try
connCallCenter.Connected:=False;
connCallCenter.connectionstring:='Provider=SQLOLEDB.1;Persist Security Info=True;'
+'User ID='+uName+';Initial Catalog='+DatabaseName+';Data Source='
+mName+';Use Procedure for Prepare=1;Auto Translate=True;'
+'Packet Size=4096;Workstation ID='+mName;
except
end;
end;
如query1.databasename 就是它