Lothar Armbrüster wrote:
> "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<UAQka.7653$pK2.8197_at_news.indigo.ie>...
>
>>The problem is probably in TNSNAMES.ORA on the client if you are using that
>>to resolve names.
>>
>>please post the SQLNET.ORA and TNSNAMES.ORA from the client...
>>"Lothar Armbrüster" <l.armbruester_at_vertriebsunion.de> wrote in message
>>news:35559896.0304082336.e2a875f_at_posting.google.com...
>>
>>>Hello out there,
>>>
>>>ich have a webservice that runs on MSIIS/W2k and connects to an Oracle
>>>9.0.1.3 Database on another W2k server via an Oracle 8.1.7 client.
>>>Whenever the webservice connects, it generates a sqlnet.log saying a
>>>connection using the bequeath protocol failed:
>>>
>>>***********************************************************************
>>>Fatal NI connect error 12560, connecting to:
>>>
>>
>>(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS=
>>'(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL
>>)(CID=(PROGRAM=c:\inetpub\scripts\vuwebservice.exe)(HOST=VU2K10)(USER=IUSR_V
>>U2K10))))
>>
> [...]
>
> Hello Telemachus,
> here they are:
>
> # SQLNET.ORA Network Configuration File:
> D:\oracle\ora81\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> NAMES.DEFAULT_DOMAIN = vu2k.vertriebsunion.de
>
> SQLNET.AUTHENTICATION_SERVICES= (NONE)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> #names.trace_directory = d:\oracle\ora81\network\trace
> #names.trace_level = ADMIN
>
> #namesctl.trace_directory = d:\oracle\ora81\network\trace
> #namesctl.trace_level = ADMIN
> #namesctl.no_initial_server = False
>
> #trace_level_client = ADMIN
>
> # TNSNAMES.ORA Network Configuration File:
> D:\oracle\ora81\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> ORA.VU2K.VERTRIEBSUNION.DE =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = vu2k07)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ora.vu)
> )
> )
>
> ORAPROD.VU2K.VERTRIEBSUNION.DE =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = vu2k08)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = oraprod.vu)
> )
> )
>
>
> ------------------
>
> ora is the development database and the one I'm connecting to. oraprod
> is the production database.
>
> Regards,
> Lothar
Very odd, indeed. According to your log, the program vuwebservice.exe
tries to connect (using beq) to the ORCL instance - and that is _not_
anyware in your tnsnames...
Some defaults, perhaps? Registry? defaults on odbc or other drivers?
--
Regards, Frank van Bortel
Received on Thu Apr 10 2003 - 13:30:39 CDT
