Re: Oracle can ONLY be connected with Oralce client

This is just a wild guess, but I think it might be possible your PATH does not point to the ODBC driver executable? On Windows, I seem to recall a problem similar to yours (sqlplus works but ODBC doesn't) and the problem was the PATH variable not being set to point to the directory where the ODBC driver dll was located.

Another potential cause... if sqlplus works, it seems unlikely your tnsnames.ora is a problem. But, I would check to ensure a "clean" TNS setup . Ensure the tnsnames.ora is in the default location ($ORACLE_HOME/network/admin) and remove any variable settings for TNS_ADMIN. Not sure about Tru64 Unix, but on Solaris it seems Oracle also likes to use a new default location of /var/opt/oracle now instead of the old default $ORACLE_HOME/network/admin .

Of course, this is kinda like trying to run in the dark with our eyes closed... it would help if you could provide error messages :)

-- 
"scottiecheng" <member44051_at_dbforums.com> wrote in message
news:3571020.1068191435_at_dbforums.com...


>

> I got a problem.

>

>

>

> We have a Oracle 8.1.6 running on Tru64 Unix platform. Before today it

> works fine, I can manipulate data via sqlplus, ODBC, and JDBC.

>

>

>

> But after I reboot the system yesterday night, I can't connect by

> ODBC/JDBC, but only can connect by Oracle Client (with tools such as

> sqlplus, sql navigator ...)

>

>

>

> I remember all I did before the reboot and previous reboot is do some

> modification with TNSNAMES.ORA file. I don't know what's going wrong

> with the Oracle, why it suddenly only can connect by Oracle Client

> instead of ODBC and JDBC ?

>

>

>

> Does anyone have any idea with this weird situation ? How do I do to

> diagnose this problem ? Please give me some advices.

>

>

>

> Thanks for any help...

>

>

>

> Scottie.

>

>

> --

> Posted via http://dbforums.com