Sql-dmo

[argoran]

I'm trying to referfence SQLDMO but everytime I try to declare it VS2005 will not accept the declaration.

I imported Microsoft.SQLServer & System.DQLCLient - then I try to Dim a variable as a new SQLServer so that I can Dim another as a SQLDMO but VS2005 just doesn't recognise either New SQL Server or SQLDMO.SQLServer.

What am I doing wrong?

Many Thanks

 

[MattP]

Project --> Add Reference --> COM tab --> Microsoft SQLDMO Object Library.

No idea what you've got planned but from there you can do:

Imports SQLDMO

Public Class Form1
    Dim server As SQLDMO.SQLServer
    Dim database As SQLDMO.Database
    Dim backup As SQLDMO.Backup
    ...
End Class

 

[jshultz]

If you are using .Net 2.0 you should use the SQLSMO object, not DMO.

 

[MattP]

If you are using .Net 2.0 you should use the SQLSMO object, not DMO.

This is true if he's using SQL Server 2005 and .NET 2.0. If that's the case then SQL-DMO was replaced with the SMO and RMO libraries.

I'd recommend that argoran heads here to get the most bang for his buck.

SMO/DMO forums

 

[argoran]

I'm trying to write a connection to a sql 2000 db and I am using .NET 2.0 ; the idea is to populate a combo box with a list of all available sql servers in the environment and let the user choose which server to connect to.
Would I reference SQLSMO the same way?

 

[JohnH]

A relevant post from thread Searching for Available SQL databases