Friday, June 18, 2010

Data provider or other service returned an E_FAIL status.

When you are trying to retirve data from oracle database from classic ASP. You will get the bellow error.

Microsoft Cursor Engine error '80004005'
Data provider or other service returned an E_FAIL status.
/localhost/file.asp, line 68


For this you need to add NVL function for the null value column