Re: Oracle Driver error

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...)

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space