sp_OACreate and MSXML2.DOMDocument.4.0

• JuanBob

  SSCertifiable

  Points: 5059

  More actions

  August 30, 2007 at 3:10 pm

  #118312

  SQL 2000

  I'm stuck on this issue and I cannot seem to find any resources.  I'll try again here.

  Running the below script runs just fine if only running a few at a time.  If I put this in a WHILE or CURSOR, it crashes SQL and stops the service.

     EXEC @hr = sp_OACreate     'MSXML2.DOMDocument.4.0', @xmlDOMObj OUTPUT

     EXEC @hr = sp_OAMethod      @xmlDOMObj, 'loadXML',         @loadResult OUTPUT, '<XML/>'

     EXEC @hr = sp_OAGetProperty @xmlDOMObj, 'documentElement', @elRoot OUTPUT

     EXEC @hr = sp_OAMethod @elRoot, 'setAttribute', NULL, 'call' , 'DoIt'

     EXEC @hr = sp_OAMethod @elRoot, 'setAttribute', NULL, 'number' , '1'

     EXEC @hr = sp_OADestroy @xmlDOMObj

  I have omitted the error catching for simplicity here. 

  Can anyone provide any information?

• JuanBob

  SSCertifiable

  Points: 5059

  More actions

  August 30, 2007 at 5:09 pm

  #730628

  Update:

  I updated to MSXML6.  I changed syntax to:

  EXEC @hr = sp_OACreate 'MSXML2.DOMDocument.6.0', @xmlDOMObj OUTPUT

  SQL Service no longer stops.  I now get the following error:

  ODBC: Msg 0, Level 19, State 1

  SqlDumpExceptionHandler: Process 59 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

   

  Connection Broken

   

  I do have SQL2000 SP4