Forum Replies Created

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

  • RE: Oracle OLEDB Password Problems

    Our servers are both 10g and 11g. The one I was testing against the most is 11g. So I thought the 11g client might help. Maybe if...

  • RE: Oracle OLEDB Password Problems

    Well, a full reinstall of the Oracle client software (Oracle ODAC 10.2.2.21) fixed things. Twice before I had tried installing the 11g ODAC software and pointing to it and...

  • RE: Oracle OLEDB Password Problems

    Okay, I tried all the ProtectionLevel nonsense about a dozen times. Plus, we reverted all packages back to the last copies that ran. All of those settings are...

  • RE: Oracle OLEDB Password Problems

    Well, it's definitely not "our company" since the only place everything broke is on the one machine where we tried to use SSIS configurations. All the other SSIS flows,...

  • RE: Oracle OLEDB Password Problems

    I'm not exactly sure what you mean by all this ...

    Our flows access SQL Server as well. And they access Oracle with the Attunity drivers. In all those...

  • RE: Oracle OLEDB Password Problems

    No, we tried all those suggestions several times. And, regardless of what we tried, we reverted everything back to just using package level passwords but those no longer work....

  • RE: Oracle OLEDB Password Problems

    I am setting persist (save password) to true. I see it true (1) in the package XML file. But it's never being saved. Either that, or it...

  • RE: Oracle OLEDB Password Problems

    That's the policy here. I'm a consultant so I'm not going to question it. I shouldn't have to change policy to get around what appears to be an...

  • RE: Oracle OLEDB Password Problems

    There is no problem with TNSNNAMES.ORA. Whether I use 10g or 11g, my TNSNAMES file points to one central place and I can connect to all Oracle databases...

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