Table of Contents

KB Item 330

Product

BIZWEAVER

Product Version (if applicable)

NA

Issue

OLE Automation error

Symptom

An error that OLE Automation is not enabled is raised when trying to make a call to the Bizweaver web service from a SQL Server stored procedure.

Cause

OLE Automation has not been enabled on this instance of SQL Server.  It is not enabled by default in a standard installation.

Resolution Notes

<p>Execute the following commands in SQL Server Management Studio.&nbsp; Restart SQL Server after they have been executed.</p><p>sp_configure 'show advanced options',&nbsp; 1;<br />GO<br />reconfigure;<br />GO<br />sp_configure 'OLE Automation procedures', 1;<br />GO<br />reconfigure;<br />GO</p><p>&nbsp;</p><pre><br /></pre>

KB Type

Solution

Item Date

14 Feb 2018