Post reply

The AcquireConnection method call to the connection manager failed with error code 0x80004005.

  • June 8, 2012 at 2:49 am

    #270831

    Hi

    I am using oracle source connector from Attunity in my SSIS package. When I am executing my package it give below error:

    [Oracle Source [1]] Error: The AcquireConnection method call to the connection manager SRC_BII failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    [SSIS.Pipeline] Error: component "Oracle Source" (1) failed validation and returned error code 0x80004005.

    [SSIS.Pipeline] Error: One or more component failed validation.

    Error: There were errors during task validation.

    I have checked google and found by changing Run64BitRuntime to false, package will execute.... but this is not working still I am facing the same problem 🙁

    Please help.

  • June 8, 2012 at 1:35 pm

    #1498915

    Have you tried doing a tnsping from the command line? Can you connect via SQL plus to the oracle instance? Are you able to ping the oracle source and telnet to the listening port that Oracle is listening on?

    It sounds like a connectivity issue, so that's why I'm asking those questions.

    Steve

  • June 12, 2012 at 12:34 am

    #1499597

    Thanks for help.

    Yes it was connectivity issue.

    After doing the connectivity, issue is resolved.

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

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