thanks for replying.
I already had given permissions but the error still stays.
Any more suggestions.
Andy Hassall <andy_at_andyh.co.uk> wrote in message news:<pj0v50l5o8svlgadf8suca6logmj50puf0_at_4ax.com>...
> On 22 Mar 2004 14:28:32 -0800, kabi_240_at_hotmail.com (karan) wrote:
>
> >I am trying to connect to a oracle database using asp and have made a
> >dsn using Oracle in OraHome92 drivers, I am getting this error:
> >Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> >Specified driver could not be loaded due to system error 5 (Oracle in
> >OraHome92).
> >I tested the connection, it shows good in ODBC administrator
> >
> >Please any ideas how to get rid of this error.
>
> The errors raised by the Microsoft driver are spectacularly useless, however
> you might want to check that whatever user your application is running as has
> the relevant permissions on the Oracle home directory - at least 'Read &
> Execute' and 'List Folder Contents'. By default your IIS user will _not_ have
> sufficient permissions after installing 9i.
>
> (And whilst you're at it - switch to the Oracle-supplied driver rather than
> the Microsoft one, unless you like being limited to version 7 functionality and
> subjected to annoying bugs. Or go the whole hog and switch to OCI...)
Received on Fri Mar 26 2004 - 11:57:44 CST
