SQLDMO: SQL2000 & VBNet2002 Std. SP2

reyboy · September 18th, 2004, 03:09 AM

'Use the SQL DMO Application Object to find the available SQL Servers
        Try
            Dim i As Integer
            Dim oNames As SQLDMO.NameList
            Dim oSQLApp As SQLDMO.Application
            oSQLApp = New SQLDMO.Application()

            oNames = oSQLApp.ListAvailableSQLServers
            cboServer.Items.Clear()
            For i = 0 To oSQLApp.ListAvailableSQLServers.Count
                cboServer.Items.Add(oSQLApp.ListAvailableSQLServer s.Item(0))
            Next i
        Catch err As Exception
            MsgBox(err.Message)
        End Try

I got this Error
QueryInterface for interface SQLDMO.NameList failed.

Any problem with code or SQLDMO it self not compatible to VBNet.

Need to Execute DMO very Badly

Proud To Be Pinoy

joefawcett · September 18th, 2004, 04:43 AM

I can see a few of things wrong, mainly the method ListAvailableSQLServers is very costly, you on ly need to call it once not three times, you never use i and the NameList is a one-based collection:

Code:

Dim i As Integer
Dim oSQLApp As SQLDMO.Application
oSQLApp = New SQLDMO.Application()
Dim colNames As SQLDMO.NameList
colNames = oSQLApp.ListAvailableSQLServers()
For i = 1 To colNames.Count
  cboServer.Items.Add(colNames(i)
Next i

--

Joe

reyboy · September 21st, 2004, 01:18 AM

Still, It fails in this part

colNames = oSQLApp.ListAvailableSQLServers()

"QueryInterface for interface SQLDMO.NameList failed"

Proud To Be Pinoy

joefawcett · September 21st, 2004, 02:10 AM

Assuming you are running SQL Server 2000 you should make sure that you have installed SQL 2000 Service Pack 2 or better still SP3.
--

Joe

reyboy · September 21st, 2004, 07:55 PM

ok. thank you very much for the responses

Proud To Be Pinoy

reyboy · September 21st, 2004, 09:14 PM

Much have been asked/Written about ADONet for VBnet but less on SQLDMO/SQLNS. Where can we find articles regarding SQLDMO/SQLNS for VBNet matter?
(Trying to create a security app in VBNet using SQLDMO/NS for SQL Server & MSDE Apps)

Proud To Be Pinoy