Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] MS ODBC for ORACLE driver connection problem!!

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

From: Justin Cave <jcave_at_cableone.net>
Date: Sun, 17 Nov 2002 10:58:22 -0800
Message-ID: <F001.00505377.20021117105822@fatcity.com>


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: jcave_at_cableone.net

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: ListGuru_at_fatcity.com (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).
Received on Sun Nov 17 2002 - 12:58:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US