Intermittent Openquery Error ..The OLE DB Provider 'MSDASQL' Indicates That The Object Has No Columns..

Help,

I am running a pass through query to oracle from SQL server 2000 as
follows;

select * from openquery(nbsp, 'select * from FND_FLEX_VALUES')

I have run this query through both DTS and the query analyzer and get
the foloowing error;

Server: Msg 7357, Level 16, State 2, Line 3
Could not process object 'select * from FND_FLEX_VALUES'. The OLE DB
provider 'MSDASQL' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to
process object, since the object has no columnsProviderName='MSDASQL',
Query=select * from FND_FLEX_VALUES'].

The really strange thing is, I'll get this error the first time I
execute the query but if I execute it immeadiatley after it will run
fine.

Any help would be most appreciated!

Cheers