September 26, 2011 at 3:54 pm
We had a working SSIS package, that was connecting to Oracle 9g and getting some data for us. After the Oracle server was upgraded to 11i , we updated the tnsnames.ora pointing to the new connection.
Using SQL Plus we are able to connect to the new host, but in our SSIS package. We see the SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ORACLE" failed with error code 0xC0202009.
And when I double click on the 'ORACLE' connection manager in SSIS package, I get the following
Test connection failed because of an error in initializing provider. ORA-06413: Connection not open.
I have Windows Server 2003 Std Edition 64 bit, SQL Server 2005 SP3 (64 bit).
I never had problem till the time the Oracle host was upgraded by our client.
Is there a need for me to update the driver for Oracle or is there specific 'dll.s' that are required for 11i support.
September 26, 2011 at 5:07 pm
Kindly ignore as problem with tnsnames.ora file.Problem fixed
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply