O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required