Error - Ole Automation Procedures[Answered] RSS

• • Reply
  jagjit saini

  Member

  47 Points

  186 Posts

  Error - Ole Automation Procedures

  Nov 08, 2020 02:48 PM|jagjit saini|LINK

  Hi

  The configuration option 'Ole Automation Procedures' does not exist, or it may be an advanced option.

  Using Express Edition Sql 2014

  Thanks

• • Reply
  Sean Fang

  Contributor

  3020 Points

  890 Posts

  Re: Error - Ole Automation Procedures

  Nov 09, 2020 03:39 AM|Sean Fang|LINK

  Hi jagjit saini,

   

  Could you please confirm that you have enabled OLE Automation procedures? 

  To prevent SQL Server to throw an exception, it is better to check first if advanced options is enabled at SQL Server configuration by calling sp_configure system procedure.

  The following example shows how to view the current setting of OLE Automation procedures.

  EXEC sp_configure 'Ole Automation Procedures';  
  GO 

  The following example shows how to enable OLE Automation procedures.

  sp_configure 'show advanced options', 1;  
  GO  
  RECONFIGURE;  
  GO  
  sp_configure 'Ole Automation Procedures', 1;  
  GO  
  RECONFIGURE;  
  GO  

   Related link:

  https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/ole-automation-procedures-server-configuration-option?redirectedfrom=MSDN&view=sql-server-ver15

   

  Hope helps.

  Best regards,

  Sean

  ASP.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today. Learn more >