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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
