In datasource designer for adding a new data source, I am attempting to connect to an oracle server. I then enter credentials and click 'test connection', and get this error.
Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect indentifier specified.
I am using Oracle 11g as my framework.
The strange thing is if i use enterprise manager using 10.2.1 oracle framework, I cannot see any tables. The only way I can see tables if I go and click on "other users" and then click on the specific user previous employees have used as their login credentials to generate an SSIS package.
I have already set up the access using enterprise manager, but ssis does not follow? Or something?
Thank you in advance.
View Complete Post