Chapter 15. ODSOLE
The surest way to corrupt a youth is to instruct him to hold in higher esteem those who think alike than those who think differently.
—Friedrich Nietzsche[1]
[1] Nietzsche, Friedrich. “The Dawn.” In The Portable Nietzsche, ed. Walter Kaufmann. New York: The Viking Press, 1954, p. 91.
In this chapter, we'll talk about automating (i.e., controlling) COM components using SQL Server's Open Data Services Object Linking and Embedding (ODSOLE) facility. ODSOLE is implemented via Transact-SQL's sp_OA extended procedures (e.g., sp_OACreate, sp_OAMethod, and so on). We'll talk about how Automation works in general, then we'll explore several examples of it using the sp_OA procs.
This chapter updates my coverage of Automation via Transact-SQL ...
Get Guru's Guide to SQL Server Architecture and Internals, The 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.
