Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-08 : 20:21:15
|
Ravi writes "I want to list all my sql server from my Local network. For that am using the SQLDMO.RLL. I have deployment the project from VB. but When I'm running those setup in the machine where I dont have SQL client/Sql server it is not able to run the code, it is saying that ActiveX Component Can not created.....I included the RLL file when I prepared deployment but still i could not able to do that.......could anyone throw some valid point to solve my problem....the code as follows
Private Sub Command1_Click()
Dim objSQLApp As New SQLDMO.Application
cmbSQLServers.Clear
For i = 1 To objSQLApp.ListAvailableSQLServers.Count
cmbSQLServers.AddItem objSQLApp.ListAvailableSQLServers.Item(i)
Next
cmbSQLServers.ListIndex = 1
Set strNameList = Nothing
Set objSQLApp = Nothing
End Sub" |
|
|
|
|
|
Sql Server List