Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: IIS Error "OraOLEDB (0x80004005)"
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...Received on Tue Mar 04 2003 - 00:50:11 CST
> 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
> >
> >
>
>