Re: ORACLE ODBC Problems
Date: Tue, 28 Jun 1994 10:01:49 -0800
Message-ID: <dischner-280694100149_at_gkc12a.klch.med.uni-muenchen.de>
In article <1994Jun27.170122.114_at_beau.atlanta.dg.com>, flg_at_atlanta.dg.com (Frank Green (Contractor)) wrote:
>
> I recently picked up the new Oracle ODBC driver set via Compuserve. I installed it on my local PC and everything apparently went smoothly, However, when I attempt to use it to link from ACCESS to Oracle on the server, my world rapidly falls apart. Everything appears to go smoothly until ACCESS tries to make the actual connection and then I get the following error messages:
>
> [Microsoft][ODBC DDL] Driver SQLSetConnectOption Failed [#0]
> [Oracle][ODBC Oracle Driver] Driver not capable [#0]
> [Oracle][ODBC Driver][Oracle OCI] ORA-12154:TNS:Cannot resolve database
> name [#12154]
>
...
> Frank Greene
Hi Frank,
you should take a look at your connect string.
It should for example look like:
T:obelix:LADA
or to bypass any troubles with hostname-resolving:
T:138.244.70.1:LADA
Check you version of ACCESS, i think 1.0 doesn't work with ODBC. (I am running V1.1)
I hope this helps,
Toni
+--------------------------------------------------------------------+ | Anton Dischner Phone: +49 89 70953202| | Institut fuer Klinische Chemie Fax : +49 89 70958888| | Klinikum Grosshadern Home : +49 89 6254060 | | Ludwig Maximilians Universitaet Muenchen Handy: +49 172 8388880| | 81366 Muenchen | | Marchioninistr. 15 | | Germany Mail: dischner_at_med.uni-muenchen.de| +--------------------------------------------------------------------+Received on Tue Jun 28 1994 - 20:01:49 CEST