error create SQLOLE.SQLServer

  • Hi, when i tried to exec a stored procedure in analyser i got an error. What does it means? Error Create SQLOLE.SQLSERVER. thanks

     


    EXEC @hr = sp_OACreate 'SQLOLE.SQLServer', @SQLServer OUT

    IF @hr <> 0

    BEGIN

    PRINT 'error create SQLOLE.SQLServer'

    RETURN

    END


     

     

  • What version of SQL Server are you using?

    For version 7 and greater, change all occurrences 'SQLOLE.SQLServer' to 'SQLDMO.SQLServer'.

    Refer to: http://support.microsoft.com/kb/q152801/

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply