Developing SQL-DMO Applications Using Visual Basic

When using an OLE Automation controller, such as Microsoft® Visual Basic®, as a SQL-DMO application development tool, you should indicate that the application references the SQL-DMO object library. A specific OLE Automation controller defines which object library reference methods it supports.

For example, using the Visual Basic Project menu item References, you can indicate that SQL-DMO will be used by the project. When you indicate that a specific object library is referenced, Visual Basic can use OLE Automation to query the object library's type library for more information about objects contained in the library. Visual Basic uses type library data to both enrich the development experience and optimize the executable application.

When an OLE Automation controller can support an object library reference at the application or project level, it is recommended that you use the feature. Though the level of programming assistance varies from controller to controller, all OLE Automation controllers can use the object library reference to optimize the executable application. Making the controller aware of the SQL-DMO library at the earliest opportunity allows it to provide you with the most efficient SQL-DMO application.

For more information about support for add-in object libraries, see the OLE Automation controller documentation.