Data provider or other service returned an E_FAIL status

[rjr23]

I'm getting this error (Data provider or other service returned an E_FAIL status) when trying to execute this statement with Visual Basic 6.0 and SQL Base 8.1.0:

SELECT SIC.CODE, V_INDUSTRY_CODES.ID, V_INDUSTRY_CODES.LONG_DESC, V_INDUSTRY_CODES.TYPE, SIC.CODE AS PK0, V_MISC_FIELDS.IS_DELETED, V_MISC_FIELDS.IS_DIRTY FROM SIC, V_INDUSTRY_CODES, V_MISC_FIELDS WHERE V_INDUSTRY_CODES.ID = SIC.CODE(+) ORDER BY SIC.CODE ASC

Any help would be appreciated.

Richard