I am having a problem connecting an oracle client to an oracle database. I am also having a problem connecting an access database to oracle using an ODBC. I have been working on this for several days and I keep getting the same error: ora-12203: TNS: unable to connect to destination.
I have only one tnsnames.ora and one sqlnet.ora files on the system, I double checked. I have modified the path variable to have both the oracle home and the net80/admin in it.
The oracle client is oracle8, I know it is old and outdated, but that is what I have to work with here.
I have not used oracle for the past 10 years, can anyone supply some assistance here.
Am I missing something?
Any help would be appreciated