Re: Webservice always tries BEQ protocol first

"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 Received on Thu Apr 10 2003 - 01:03:04 CDT