Re: Configure DAD to call stored procedure from Internet Explorer

Dear Holger,
Thanks for your help. I respect your time you spend for me. You're true ! If we have only Oracle Enterprise Server on machine, we must use Basic Authentication in DAD.

However, my DAD doesn't not work (Service Temporarily Unavailable). Mr Peter Finnigan (in this group) gave me a link: http://groups.google.com/groups?q=htf+htp+asset+norman+oracle&hl=en&lr=& ie=UTF-8&oe=utf-8&safe=off&selm=E2F6A70FE45242488C865C3BC1245DA7033C1048 %40lnewton.leeds.lfs.co.uk&rnum=2 - which solved my problem: Beside authentication mode, we must give the correct connect string: If our database service is Tiny (with SID is TinySID) and the server is running on our machine. The correct connect string is: TINY (not TINYSID or localhost:1521:TINYSID as suggested by oracle document). I hope this will help those whose are crazy to solve the same problem like me.

Thanks a lot Mr.Holger

" Hai Ly Hoang [MT00KSTN]" <Mail_at_Home.net> wrote in message news:bq7peh$1vfdte$1_at_ID-193509.news.uni-berlin.de...
> Dear Holger,
> I changed the authentication mode to basic (and all other modes). But the
> result is the same: "Service Temporarily Unavailable".
> Do you have any other suggestions?
> Thanks.
>
> "Holger Baer" <holger.baer_at_science-computing.de> wrote in message
> news:bq7mu0$a7o$1_at_news.BelWue.DE...
> > Hai Ly Hoang [MT00KSTN] wrote:
> > > After installing Oracle 9.01 Enterprise Sever (Windows OS), I created
> an
> > > user named xuanthu and created some table and a procedure 'Helo' (by
> CREATE
> > > TABLE....). Now i want to call Helo from Internet Explorer.
> > > I open Pl/SQL gateway and create an DAD with the following
> configuration:
> > > (Oracle server is running on my computer)
> > >
> > > Database Access Descriptor Name: myDAD
> > > UserName:xuanthu
> > > Password:****
> > > ConnectString: localhost:1521:tinysid
> > >
> > > (the following is default options given by DAD wizard)
> > > Authentication Mod: Single-signon
> > > Session Cookie: (blank)
> > > Package/Session Management Type: Stateless
> > > Enable Connection Pooling? yes
> > > Document Table : XuanThu .wwdoc_document
> > > Document Access Path: docs
> > > Document Access Procedure: XuanThu .wwdoc_process.process_download
> > > Extensions to be uploaded as Long Raw: blank
> > > Path Alias : url
> > > Path Alias Procedure : XuanThu .wwpth_api_alias.process_download
> > >
> > > In internet explorer, i call: http://localhost/pls/mydad/helo . I just
> > > received this message:
> > > "Service Temporarily Unavailable
> > > The server is temporarily unable to service your request due to
> maintenance
> > > downtime or capacity problems. Please try again later. "
> > >
> > > File Oracle9i\Apache\Apache\logs\error_log show that:
> > > [Fri Nov 28 20:52:59 2003] [error] mod_plsql: /pls/mydad/helo HTTP-503
> > > ORA-12560 <B>Proxy log On failed.</B><BR>Please verify that you have
> > > specified correct connectivity information i.e. username, password &
> > > connect-string in the DAD
> > >
> > > WHAT'S WRONG ? Can anyone help me ?
> > >
> > > (Oh, I'm sure that my Database SID (declared in ConnecString is
> TinySID).
> > > But if i want to check it again (ie. get the SID of the database), how
> to do
> > > it (by wizard or SQL command) ?
> > >
> > > Thanks alot and alot !
> > >
> > >
> > >
> >
> > Single-Signon is for Oracle Portal, which you don't have. Try using
> > Basic authentification.
> >
> > HTH
> >
> > Holger
> >
>
>
Received on Fri Nov 28 2003 - 22:33:36 CST