Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SS7,VB5,VB6
Expertise: Intermediate
Apr 29, 2000

Listing all available SQL Server

Thanks to the SQL-DMO object model, it's very easy to list all the available SQL Server 7.0 installations. For example, this code loads all the SQL Servers registered on the local machine into a ComboBox control:


' NOTE: this code assumes that you've added a reference to the
'       SQL-DMO type library in the References dialog box

Dim sqlApp As New SQLDMO.Application
Dim NameList As SQLDMO.NameList
Dim index As Long
    
Set NameList = sqlApp.ListAvailableSQLServers
cboServers.Clear
' local SQL Server must be added manually
cboServers.AddItem "."        
For index = 1 To NameList.Count
    cboServer.AddItem NameList.Item(index)
Next
Francesco Balena
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date