RE: [Q] MS ODBC for ORACLE driver connection problem!!

2002-11-18 Thread Charu Joshi
Try using the 'Home Selector' utility to set the appropriate default home
and then give it a go.

Regards,
Charu.

-Original Message-
Sent: Friday, November 15, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L

We are testing the ORACLE 9iR2 client server connection.  On PC side, we
installed ORACLE ODBC driver 9.2.0.2 and upgrade MS ODBC for ORACLE to
2.573.9001.000.  After configuration, ORACLE ODBC driver work fine, but MS
ODBC for ORACLE have ORA-12154 (TNS name can NOT resolve) error.  I
trouble shooting the problem and found MS ODBC for ORACLE ONLY check
\orant\network\admin\tnsnames.ora.  The path we installed ORACLE client
on \oracle\9.2\.  Does anyone know how to fix this problem?

Thanks.

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: dist cash
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charu Joshi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: [Q] MS ODBC for ORACLE driver connection problem!!

2002-11-17 Thread GL2Z/ INF DBA BENLATRECHE
 HI,

 May be the version of the ODBC is not compatible with the SQLNET you
installed. I had a problem between Oracle 8i Client and ODBC V2.5. I
resolved it by adding SQLNET.V2 on the client side.


 --
 De :  dist cash[SMTP:[EMAIL PROTECTED]]
 DateĀ :vendredi 15 novembre 2002 14:58
 A :   Multiple recipients of list ORACLE-L
 Objet :   [Q] MS ODBC for ORACLE driver connection problem!!
 
 
 
 
 
 We are testing the ORACLE 9iR2 client server connection.  On PC side, we
 installed ORACLE ODBC driver 9.2.0.2 and upgrade MS ODBC for ORACLE to
 2.573.9001.000.  After configuration, ORACLE ODBC driver work fine, but MS
 ODBC for ORACLE have ORA-12154 (TNS name can NOT resolve) error.  I
 trouble shooting the problem and found MS ODBC for ORACLE ONLY check
 \orant\network\admin\tnsnames.ora.  The path we installed ORACLE client
 on \oracle\9.2\.  Does anyone know how to fix this problem?
 
 
 Thanks.
 
 
 
 _
 STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
 http://join.msn.com/?page=features/junkmail
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: dist cash
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: [Q] MS ODBC for ORACLE driver connection problem!!

2002-11-17 Thread Yechiel Adar
Put a copy of tnsnames where MS ODBC wants it?
Check if MS ODBC support name server or Directory services?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 15, 2002 4:58 PM






 We are testing the ORACLE 9iR2 client server connection.  On PC side, we
 installed ORACLE ODBC driver 9.2.0.2 and upgrade MS ODBC for ORACLE to
 2.573.9001.000.  After configuration, ORACLE ODBC driver work fine, but MS
 ODBC for ORACLE have ORA-12154 (TNS name can NOT resolve) error.  I
 trouble shooting the problem and found MS ODBC for ORACLE ONLY check
 \orant\network\admin\tnsnames.ora.  The path we installed ORACLE client
 on \oracle\9.2\.  Does anyone know how to fix this problem?


 Thanks.



 _
 STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
 http://join.msn.com/?page=features/junkmail

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: dist cash
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: [Q] MS ODBC for ORACLE driver connection problem!!

2002-11-17 Thread Justin Cave
At 07:58 AM 11/15/2002, dist cash wrote:

We are testing the ORACLE 9iR2 client server connection.  On PC side, we
installed ORACLE ODBC driver 9.2.0.2 and upgrade MS ODBC for ORACLE to
2.573.9001.000.  After configuration, ORACLE ODBC driver work fine, but MS
ODBC for ORACLE have ORA-12154 (TNS name can NOT resolve) error.  I
trouble shooting the problem and found MS ODBC for ORACLE ONLY check
\orant\network\admin\tnsnames.ora.  The path we installed ORACLE client
on \oracle\9.2\.  Does anyone know how to fix this problem?


Note that Microsoft has not certified their latest ODBC driver against 
Oracle 9.  The recommend staying with the 8.1.7 Oracle client if you want 
to use their driver.
Justin Cave
Distributed Database Consulting

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Justin Cave
 INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


[Q] MS ODBC for ORACLE driver connection problem!!

2002-11-15 Thread dist cash




We are testing the ORACLE 9iR2 client server connection.  On PC side, we
installed ORACLE ODBC driver 9.2.0.2 and upgrade MS ODBC for ORACLE to
2.573.9001.000.  After configuration, ORACLE ODBC driver work fine, but MS
ODBC for ORACLE have ORA-12154 (TNS name can NOT resolve) error.  I
trouble shooting the problem and found MS ODBC for ORACLE ONLY check
\orant\network\admin\tnsnames.ora.  The path we installed ORACLE client
on \oracle\9.2\.  Does anyone know how to fix this problem?


Thanks.



_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: dist cash
 INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).