Hi,
I need to connect to Oracle database from SQL Server. And for this, I was told to install Oracle ODBC driver. I downloaded Oracle ODBC Driver 9.0.1.8.0 and installed it (the installation was successful.). Then, I was trying to create DSN and couldn't find the driver in the list and I am stuck here and don't know what to do.. Am I doing anything wrong ? Or do I need to do anything else ? Please let me know if anybody has any ideas.
The version of Oracle we are having is Oracle 9i (9.2.0.4.0)
The version of SQL Server is 2005
Operating System is Windows 2003 Enterprise Edition (Service Pack 1)
Also, tried on XP Profesional (Service Pack 2)
Any help is appreciated.
Thank you,
Aparna.