Hi,

Thanks for your response.
If Erwin talks to Oracle without any hazzle, then why is mine not working??
These are the steps I followed :
1. Set up a system DSN on any machine for Oracle ODBC Driver 8.01.06 using the service name.
2. Open up Erwin and then set the target server to Oracle 8.x
3. Click on Oracle Connection and fill in the username/password, along with the DSN name.
4. And when I click 'connect', the screen just stays there, giving neither an error message nor a 'connected' message.

To think that anything could be wrong with the service name - I am able to use a 3rd party tool to export and import table data to and from the Oracle database without any poblem using the same DSN.
Is there anything like the DSN should reside in the same machine as the server for Erwin(though it is highly unlikely...)?
What do you think the problem could be?

Shiva.