sp_OAMethod

• elham_azizi_62

  SSCertifiable

  Points: 5095

  More actions

  January 20, 2013 at 2:23 am

  #273201

  hello all.

  I use this:declare @h int,@objDBC int

  EXEC sp_OACreate 'ADODB.Connection', @objDBC OUT

  --------@objDBC =16711422

  EXEC @h=sp_OASetProperty 16711422,

  'ConnectionString', 'Driver={SQL Server};

  Server=WIN-00UO3RQ0BM3;

  Database=MaliGilan;

  trusted_Connection=Yes'

  EXEC @h=sp_OAMethod 16711422, 'Open'

  print @h

  this have to returns zero but returns -2147467259.

  please tell me why this dosen't return zero?

• Damian Widera-396333

  Ten Centuries

  Points: 1186

  More actions

  January 20, 2013 at 5:30 am

  #1579017

  Have you enabled the OA in the server? Please check this via sp_configure:

  sp_configure 'show advanced options',1

  GO

  reconfigure

  GO

  sp_configure 'Ole Automation Procedures'

  You should see the run_value as 1. If not - set it to 1 and check the code one more time

  Kindest Regards,

  Damian Widera
  SQL Server MVP,
  MCT, MCSE Data Platform, MCSD.NET

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  January 20, 2013 at 8:08 am

  #1579024

  You could also consider switching to use a Linked Server to connect to a remote SQL Server instead of using the OLE Automation routines.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato