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

Recap

COM is a powerful and pervasive technology that enables applications to interoperate in a wide variety of ways. Thanks to ODSOLE, Transact-SQL can access COM object interfaces exposed by other applications and even by SQL Server itself. By combining the power of a relational database with the flexibility and ubiquity of Automation, you can build applications that are very powerful indeed.

SQL Server's ODSOLE facility uses late binding to interact with COM objects. This means that it makes calls to the IDispatch COM interface, similarly to traditional scripting languages such as VBScript and JScript.

ODSOLE makes use of the STA threading model. When first initialized, it creates the main STA if it has not already been created. In the STA ...

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