I like to migrate the data from Oracle9i Enterprise Edition Release 9.2.0.8.0. This oracle is running in remote system. I can only communicate with server through Nortel VPN tool. I have installed SSMA 2005 in my system.
Aim: Import the all the table along with records from oracle(remote) to my sql server(local)
When I am connecting with oracle using SSMA 2005 tool, i am receiving following error
Connection to Oracle failed.
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Please help me how to avoid this and tell me how to achieve my aim.