intermittent openquery error "..The OLE DB provider 'MSDASQL' indicates that the object has no columns.."

[Kevin]

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

[Simon Hayes]

"Kevin" <ke***********@nbs.nhs.uk> wrote in message
news:3f**************************@posting.google.c om...

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

There are a couple of KB articles for error 7357, but they only relate to
situations where the query doesn't return a result set, which doesn't seem
to be the case with your query:

http://support.microsoft.com/default...&Product=sql2k
http://support.microsoft.com/default...&Product=sql2k

Is there some reason why you're using the ODBC OLE DB provider instead of
the Oracle one (MSDAORA)? You might want to try the Oracle one to see if
that makes a difference, and upgrading MDAC to the latest version might also
be worth a try.

Simon