Creating Applications with SQL-DMO

You can use SQL-DMO using Transact SQL, in Active Server Pages or build entire applications around SQL-DMO. To build a SQL-DMO application or component requires a 32-bit programming language that can create OLE controller applications. Tools such as Microsoft Visual C++, a Windows-based Java tool, or Microsoft Excel for Windows NT with 32-bit VBA (Visual Basic for Applications) can easily be used. The examples and code samples shown in this chapter are based on Microsoft Visual Basic 6.0. The choice of Visual Basic is easy because it is the most popular and rapid application-development tool available. The core language of Visual Basic 6.0 is VBA and can be found in Office 2000 (that is, Access, Word, PowerPoint, ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.