Re: ORACLE ODBC Problems

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 for TCP/IP:hostname:case sensitive database name.

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|
+--------------------------------------------------------------------+