Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Unanswered: SP_OACreate in SQL Server 2005, Fails with 'Not enough storage is available to...'


    I am trying to call dot net dll from an SP but its not working and throws an ODSOLE Extended Procedure type of error saying "Not enough storage is available to complete this operation."

    Please HELP!!!!

    Here is SP code from where i tried to call Dot Net dll.

    DECLARE @comHandle INT
    DECLARE @retVal INT
    DECLARE @errorSource VARCHAR(100)
    DECLARE @errorDescription VARCHAR(100)
    DECLARE @ReturnedString VARCHAR(2000)

    EXEC @retVal = sp_OACreate 'FileadeCOMnet.RaeBridge', @comHandle OUTPUT

    IF (@retVal <> 0)
    EXEC sp_OAGetErrorInfo @comHandle, @errorSource OUTPUT, @errorDescription OUTPUT
    SELECT @errorSource, @errorDescription

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Based on past experience (and supported by KB932872), you need to compile your code with a 64 bit compiler in order for this to work.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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