Re: Oracle can ONLY be connected with Oralce client

Okay, i'm just gonna repeat what the guys above allready told you:

You changed the Tnsnames.ora settings.

Okay, test-thingie:

Say in the tnsnames.ora it first read:

DB01.WORLD=...... You made a ODBC connection, a JDBC connection, etc.etc. and you had to use "DB01.WORLD" in the connect string.

Now you changed "DB01.WORLD" to, oh, let's say "DB01" or "DB02" or
"DB01.NY.AMERICA.WORLD" or etc.etc...

But the ODBC and JDBC connection still use the "DB01.WORLD" and cannot find it anymore in the tnsnames.ora.

Hope this clears it up for you..

Oh, and if you REALLY need the new value in your TNSNAMES.ora, try the following:

Instead of changing the old value (DB01.WORLD) to the new value (DB01), just ADD another value:

DB01.WORLD, DB01 = ... This way you do not need to change the ODBC and the JDBC connection, but still can connect with them in the old way, and use your new alias for whatever reason you changed it.

Oh, an next time you post a problem, please provide some more information. As you can read, I had to make a lot of assumptions, and maybe they're all wrong because you also could have changed the
"HOST=.." value, or the "PORT=.." value, or..,or..

Get it?

Thanks and good luck!

:)

--
Posted via http://dbforums.com