大家好!请教CSDN里的朋友们一个问题,在一个局域网里,一台机子作为服务器,上面装了sql server 2000,其他的客户机上没有装。问题是客户机如何连接sql server 2000???我写了一段代码,但是不管用,麻烦大家帮忙看一下。
procedure TForm1.Button1Click(Sender: TObject);
var
servername,databasename,ad,password:string;
connect:string;
begin
servername:=combobox1.Text;
databasename:=combobox2.Text;
ad:=edit3.Text;
password:=edit4.Text;
form1.ADOConnection1.Close;
connect:='Provider=SQLOLEDB.1;Password='+password+';Persist Security Info=false;User ID='+ad+';Initial Catalog='+databasename+';Data Source='+servername;
form1.ADOConnection1.ConnectionString:=connect;
form1.ADOConnection1.CommandTimeout:=10;
try
form1.ADOConnection1.Open;
form1.ADOConnection1.Connected:=true;
application.MessageBox('数据连接成功!','系统提示',0+64);
except
application.MessageBox('数据库连接失败!','系统提示',0+64);
end;
end;
连接的时候,会发生异常,弹出数据库连接失败,不知道程序什么地方有毛病???
procedure TForm1.Button1Click(Sender: TObject);
var
servername,databasename,ad,password:string;
connect:string;
begin
servername:=combobox1.Text;
databasename:=combobox2.Text;
ad:=edit3.Text;
password:=edit4.Text;
form1.ADOConnection1.Close;
connect:='Provider=SQLOLEDB.1;Password='+password+';Persist Security Info=false;User ID='+ad+';Initial Catalog='+databasename+';Data Source='+servername;
form1.ADOConnection1.ConnectionString:=connect;
form1.ADOConnection1.CommandTimeout:=10;
try
form1.ADOConnection1.Open;
form1.ADOConnection1.Connected:=true;
application.MessageBox('数据连接成功!','系统提示',0+64);
except
application.MessageBox('数据库连接失败!','系统提示',0+64);
end;
end;
连接的时候,会发生异常,弹出数据库连接失败,不知道程序什么地方有毛病???
var
servername,databasename,ad,password:string;
connect:string;
begin
servername:=combobox1.Text;
databasename:=combobox2.Text;
ad:=edit3.Text;
password:=edit4.Text;
form1.ADOConnection1.Active:=false;
connect:='Provider=SQLOLEDB.1;Password='+password+';Persist Security Info=false;User ID='+ad+';Initial Catalog='+databasename+';Data Source='+servername;
form1.ADOConnection1.ConnectionString:=connect;
form1.ADOConnection1.CommandTimeout:=10;
try
form1.ADOConnection1.active:=true;
form1.ADOConnection1.Connected:=true;
application.MessageBox('数据连接成功!','系统提示',0+64);
except
application.MessageBox('数据库连接失败!','系统提示',0+64);
end;
end;
var
servername,databasename,ad,password:string;
connect:string;
ok: boolean;
begin
servername:=combobox1.Text;
databasename:=combobox2.Text;
ad:=edit3.Text;
password:=edit4.Text;
connect:='Provider=SQLOLEDB.1;Password='+password+';Persist Security Info=false;User ID='+ad+';Initial Catalog='+databasename+';Data Source='+servername;
//
form1.ADOConnection1.ConnectionString:=connect;
form1.ADOConnection1.CommandTimeout:=10;
try
form1.ADOConnection1.Connected:=true;
ok:=form1.ADOConnection1.Connected;
except
ok:=false;
end;
//
if ok then
application.MessageBox('数据连接成功!','系统提示',0+64)
else
application.MessageBox('数据库连接失败!','系统提示',0+64);
end;
form1.ADOConnection1.Connected:=true;
form1.ADOConnection1.Open;