I have client tools 10g release 2 for both 32 and 64 bit installed the destination is 10g release 2 64 bit. And I can use SQL Plus to connect to the defined TNS name from both home folders.
I am running Windows Server 2003 x64 and SQL Server 2008 with the latest updates.
When I try to create a new Oracle Connection using the Oracle Connection Manager Editor I get the error "Error at (Name) [Connection manger "(Name)"]: OCI error encountered. ORA-12154: TNS:could not resolve the connect identifier specified.
I can TNSping the TNS service name, if I create an ODBC connection using the service name I can communicate with the Oracle environment. Because of the promise of better performance using the Attunity/Microsoft SSIS Oracle Connector I want to try to get it to work.
Does anyone have any recommendations or advice?