April 3, 2008 at 9:07 pm
Hi,
I have given up with trying to get a plain OLE DB Connection to oracle working and i'm now trying ADO.net.
The problem I am having is it doesn't matter which provider i use with an ADO.NET connection it won't remember my password.
I have tried the following Providers
OracleClient Data Provider (.net)
Odbc Data Provider (.net)
MS OLE DB Provider for Oracle (Oledb)
Any help would be great
Thanks
Patrick
April 4, 2008 at 6:39 am
All of the providers work fine.
Make sure you are using a compatible oracle client (10g works well - many older clients are less than compliant with a lot of software).
SSIS does not like to remember any passwords. The best solution I have found is to use package configurations.
Interestingly, the oracle OLEDB providers do not like having anything other than the password and server name stored in the config file - I have found that if you include other attributes it does not work.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply