procedure TForm1.FormCreate(Sender: TObject); var SQLServer:Variant; ServerList:Variant; i,nServers:integer; begin SQLServer := CreateOleObject('SQLDMO.Application'); ServerList:= SQLServer.ListAvailableSQLServers; if serverlist.count<1 then begin //如果服务器不存在,则退出系统 showmessage('服务器不存在,请检测服务器是否已经开机或者服务是否打开了'); application.Terminate; end else begin for i:=1 to serverlist.count do listbox1.Items.Add(serverlist.item(i)) ; showmessage(serverlist.item(1)+'服务器已经打开,可以正常使用本系统'); //adoconnection1.ConnectionString:='Provider=SQLOLEDB.1;Persist Security info=False;UserID=sa;InitialCatalog=ideal_db;DataSource='+ServerList.Item(1); end; SQLServer:=NULL; serverList:=NULL; end;
至于取所有数据库名,可用SQL语句来取: select name from master.dbo.sysdatabases 返回值即是数据库名列表.
----------------------------------------------
-广袤璀璨的银河,永无止境的梦想(梦无止境游银河) 博客挂了……