Re: MS Access v2/ODBC v1.0/Oracle7
Date: 15 Aug 1994 11:05:02 -0400
Message-ID: <32o06u$1fp_at_search01.news.aol.com>
In article <3130st$id9_at_yoda.Syntex.Com>, lac_at_cowdreyl.syntex.com writes:
>I am getting:
>[Microsoft][ODBC DLL] Driver's SQLSetConnectOption failed [#0]
>[Oracle][ODBC Oracle Driver]Driver not capable. [#0]
>[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-06107: NETTCP: ORACLE
>network
>server not found. [#6107]
>whenever I try to attach an Oracle7 table to an Access v2 database.
>I have tried reinstalling ODBC v1.0 and Oracle's driver for Oracle7
>Oracle7 ODBC Driver Version 1.1.0.0 (Level 1 Driver), but I still
>get this wonderful message. However, MS Query and the ODBC Test
>program by Oracle both work fine without any problems and return
>the expected results.
*-----------------------------------------------------Funny you should ask this. (Well, it's not funny-- I recently went through this hell myself.)
First of all, make sure that the hosts and services address translation files are loaded in the right place on your workstation for the TCP/IP stack software to access them; SQL*Net TCP/IP also needs to access the SERVICES file, and the TCP_SERVICES_FILE entry in your ORACLE.INI should reflect the location of this file.
Second, the version of TCP/IP SQL*Net for Windows you have might have a bug in it that can be fixed by using the following modified connect string:
t:hostnam/1525:instancenam
where hostnam is the UNIX node name of your server,
1525 (or the appropriate entry from your host's /etc/services file)
represents the
services address for the listener
instancenam is your Oracle instance
Later versions of SQL*Net TCP/IP v1.x seem to not have this problem; the one I just installed from CD-ROM has this bug corrected.
Good luck!
R. (Scott) Hunter shunter_at_cfotax.attmail.com Database Administrator
AT&T Tax Systems, Financial Services Organization AT&T Corporation - Morristown, NJ
Received on Mon Aug 15 1994 - 17:05:02 CEST