Re: Webservice always tries BEQ protocol first

From: Chuck Shugar <cashugar_at_mindspring.com>
Date: Fri, 11 Apr 2003 21:58:14 -0500
Message-ID: <b77vc8$4s7$1@slb9.atl.mindspring.net>

Have you tried adding the statement:

 automatic_ipc=off

to the SQLNET.ORA file on the webservice client?

Chuck.

"Frank" <fvanbortel_at_netscape.net> wrote in message news:3E95B84F.1010806_at_netscape.net...
> 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)(ARG S=
>
>>'(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=OR CL
>
>>)(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 Fri Apr 11 2003 - 21:58:14 CDT