SQLDMO error

  • Thread starter Thread starter Nanda
  • Start date Start date
N

Nanda

when i run this code, i get
QueryInterface for interface SqlDmo.Namelist failed.

Dim sqlApp As New SQLDMO.Application
Dim NL As SQLDMO.NameList

Set NL = sqlApp.ListAvailableSQLServers
For index = 1 To NL.Count
cboServers.AddItem NL.Item(index)
Next

What could be the error.

Regards,
Nanda.
 
Nanda,

Installing the latest SQL service pack on the client should fix it.



Mattias
 
Hi,
thanks for your reply.
where can i download the later sp. could u give my any link.

Thanks & Regards,
Nanda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where to find SQLDMO? 2
How to use the ListAvailableSqlServers in c# 5
SQLDMO failing to enumerate sql servers in vb 3
Problem using SQLDMO to get list of available SQL servers 3
Problems with ListAvailableSQLServers (SQLDMO) 1
SQLDMO Problem 1
SQL-DMO problem 1
List SQL servers in a network 5

Back
Top