Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: IIS Error "OraOLEDB (0x80004005)"

Re: IIS Error "OraOLEDB (0x80004005)"

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 4 Mar 2003 06:50:11 -0000
Message-ID: <3e644ca6$0$227$cc9e4d1f@news.dial.pipex.com>


NB cross posting severely cut.

I suspect HK will find that the IIS user account doesn't have correct access to the ORACLE_HOME directory, it needs at least read and execute.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Jeff Dillon" <jeffdi_at_fidalgo.net> wrote in message
news:OlYsWcd4CHA.2644_at_TK2MSFTNGP11.phx.gbl...

> That error generally means "Access Denied".
>
> Are you sure you are using a correct username and password?
>
> Jeff
>
> "HK Chang" <REMOVETHIS_hkchang_at_bigfoot.com> wrote in message
> news:b3uqtg$i8k$1_at_news.hgc.com.hk...
> > Dear All,
> >
> > Do you know why the error OraOLEDB (0x80004005) occur?
> >
> > I am now using a W2K server and Oracle 9i Release 2. They are installed
in
> > the same machine.
> >
> > I have use the following code:
> > <%
> > option explicit
> > dim con
> > dim rs
> > dim i
> > dim sql
> >
> > set con = createobject("adodb.connection")
> > con.connectionstring = "Provider=OraOLEDB.Oracle;Data
Source=ffis07db;User
> > ID=uid;Password=pwd;"
> >
> >
> > con.open
> >
> > sql = "select * from cc_mas"
> >
> > set rs = createobject("adodb.recordset")
> > rs.open sql, con
> >
> > do until rs.eof
> > for i = 0 to rs.fields.count - 1
> > if not isnull(rs(i)) then Response.Write (rs(i))
> > next
> > Response.Write
> > rs.movenext
> > loop
> > %>
> >
> >
> > Then get the following errors:
> > Error Type:
> > OraOLEDB (0x80004005)
> > ???
> > /bcase/test.asp, line 13
> >
> > Do you have any idea?
> >
> > Thanks.
> >
> > Regards,
> > HK Chang
> >
> >
>
>
Received on Tue Mar 04 2003 - 00:50:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US