Re: Problems with ODBC & Sqlnet V2 in MS Word
From: Ammon W.H. Lee <whlee_at_hk.super.net>
Date: 26 Mar 1995 04:36:39 GMT
Message-ID: <3l2r0n$d52_at_tst.hk.super.net>
> When using Oracle's ODBC driver for Oracle7 in conjunction with
> SQL*Net V2 TCP/IP and MS Word's Mail Merge (in the Tools menu),
> I bomb with ORA 12154 (generic "You're tnsnames.ora file is hosed)
> Here is the scenario:
>
Date: 26 Mar 1995 04:36:39 GMT
Message-ID: <3l2r0n$d52_at_tst.hk.super.net>
Steve Helle <shelle_at_dbintellect.com> wrote:
>
> When using Oracle's ODBC driver for Oracle7 in conjunction with
> SQL*Net V2 TCP/IP and MS Word's Mail Merge (in the Tools menu),
> I bomb with ORA 12154 (generic "You're tnsnames.ora file is hosed)
> Here is the scenario:
>
I come across similar problem. Here I'm using Oracle 7.1.3 on Solaris I tried to access the server through MS Access 2.0 using ODBC driver ver 1.10.0000. I found that I can only attach tables when I first started Access. After the first time attachment, I will get error , saying that 'TNS lookup failure' when I tried to do attachment again. However everything goes fine when I do the query in MS Query! I've contacted the Oracle support. They simply send me a new version of ODBC driver (1.11.0000) but in vain. The same thing happens again. Can anyone out there shed light on this area please!!!!!
Ammon W.H. Lee
whlee_at_hk.super.net
Received on Sun Mar 26 1995 - 06:36:39 CEST