Receiving ORA-12154 When trying to connect

[salred]

I'm trying to connect to my project's Oracle9i EA repository, but with no luck.

I'm running EA 6.0.780; OS is WinXP Pro SP2

I tried installing MDAC 2.8, but Windows said that XP already has those features, so never mind.

I installed the current Oracle10g Provider for OLE DB (10.1.0.4.0)

I've added the server TNS names entry for the EA repository database.

When I test my connection I get an MS Data Link Error that cites "ORA-12154:TNS:Could not resolve the connect identifier specified"  On the other hand I *can* connect to the EA repository DB through SQL*Plus on the same machine.

Any theories?

Thanks,
Steve Alred
(US) National Cancer Institute
Cancer Data Standards Repository Project

[salred]

OK, it was simple after all.

My installation of the Oracle Provider for OLE DB created yet another network\admin directory on the "D:" partition of my PC.  Once I found it and added a correct tnsnames.ora file I could connect to EA.
(I had been looking for and modifying tnsnames.ora files on the "C:" partition.  And what's with those files anyway, they seem to multiply like rabbits.)

Steve A.

[thomaskilian]

Like programs you expect to reside in C:\programs but they are somewhere else