Post reply

Error using sp_oaMethod in proc to automate DTS

  • February 10, 2003 at 3:40 am

    #81501

    Hello,

    I have a stored proc which uses the extended system stored procs (sp_oa....) to automate a DTS package.

    sp_oaCreate runs ok, but sp_oaMethod called with "LoadFrpmSQLServer" fails with the message "OLE32.DLL has been loaded at the wrong address"

    Works file on development and acceptance boxes, but not on Live. How embarrassing is that?

    Can't see any immediately obvious config differences. Any pointers will be most gratefully received.

  • February 10, 2003 at 3:09 pm

    #448582

    Have you checked the versions of that DLL on each of the servers? Also, check if there are multiple copies of that DLL. Might have the wrong one registered.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

  • February 11, 2003 at 2:29 am

    #448592

    Yep - done all that

    everything is consistent across servers (or so 'm told by our network bods ...)

  • February 11, 2003 at 3:06 am

    #448595

    Hate to be a stick pointer ... but I've been in the same situation in regards to Network bods. One response I got was "Oh I didn't think that was an important application"

    Obviously there is something different with that DLL between the environments. What about applications that are in production but not on the dev server, and vice-versa?

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

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

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