January 5, 2012 at 4:38 pm
I'm getting the following error when I try to create a connection mgr to connect to Oracle in VS 2008.
I'm using the Provider called "Native OLE DB\Microsoft OLE Provider for Oracle
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specified
------------------------------
BUTTONS:
OK
------------------------------
January 6, 2012 at 8:26 am
Ok, I have another issue so please disregard the previous post.
The issue I have now is that I have an OLE DB source using a connection mgr that is using the Native OLE DB\Microsoft OLE DB Provider For Oracle.
When in design mode I can preview the data but when I execute the pkg I get the following errors (I have all connection mgrs and dataflow tasks and oledb src set to delay data validation):
[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SBORPTP" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[SSIS.Pipeline] Error: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
[SSIS.Pipeline] Error: One or more component failed validation.
Error: There were errors during task validation.
[Connection manager "SBORPTP"] Error: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider MSDAORA.1 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000.
I was just told that our enviroments are 32 bit so the last error baffles me....I am rdc'ing into a 32 server with a 64 bit laptop but that shouldn't matter.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply