Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Canada
    Posts
    45

    Question Unanswered: sp_OACreate 'SQLXMLBulkLoad.SQLXMLBulkload' in 2005

    With my Sql server I install SQLxml3.0 and run this with problem.
    Code:
    DECLARE  @ObjectError INT
          , @Object      INT
          , @ErrMsg      VARCHAR(50)
    
    EXEC @ObjectError = sp_OACreate 'SQLXMLBulkLoad.SQLXMLBulkload', @Object OUT,4
    I plan to go with the Sql server 2005 but this code give me a error...
    Msg 15281, Level 16, State 1, Procedure sp_OACreate, Line 1

    SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ole Automation Procedures' by using sp_configure. For more information about enabling 'Ole Automation Procedures', see "Surface Area Configuration" in SQL Server Books Online.
    My user right not change. And I dont see some "SQLXML" in the "Surface Area Configuration"???

    Can someone can give my suggestion?
    Franky
    FBoucheros@hotmail.com

  2. #2
    Join Date
    Jun 2003
    Posts
    269
    By default SMO and DMO XPs are disabled in SQl2005 for security reason.
    To enable execute below code,
    Code:
     
    sp_configure 'show advanced options', 1;
     
    GO 
     
    RECONFIGURE;
    GO
     
    sp_configure 'SMO and DMO XPs', 1;
     
    GO
     
    RECONFIGURE
    GO
    cheers
    Last edited by mallier; 01-31-06 at 07:20.
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •