Hi,
I am facing some problems with oracle connectivity on Windows with DS6.0.The oracle client software is properly working I am getting an error
"ORA-12358.TNS no such protocol adapter" when i try to do import through manager.
But through designer and manager I am able to connect the same using an ODBC which i have created on DS Server.But is not happening using OCI 8 plugin.Can anybody let me know what else i can check....
Enviornment:
DS6.0 on Windows
Oracle on Windows
Oracle Connectivity Problems
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
The protocol adaptor is a dll file, it looks like it is missing or not registered. If you can turn Oracle trace on it will show you the name of the shared library (or DLL) file that could not be loaded.
Best fix is to take dtsipe's advice and reinstall the Oracle client.
Vincent McBurney
Data Integration Services
www.intramatix.com
Best fix is to take dtsipe's advice and reinstall the Oracle client.
Vincent McBurney
Data Integration Services
www.intramatix.com