Posted by John Bell on 09/29/15 11:45

Hi

Try using two part names for your oracle table by adding the schema that
your oracle table is in.

John

"ProgrammerGal" <carolyn_graf@ahm.honda.com> wrote in message
news:1145398887.423877.242610@t31g2000cwb.googlegroups.com...
>I tried all different versions of the selects... no luck.
> Still the same "no schema exposed message"
>
>
> Here is the error from the delete...
>
> delete from openquery([Notes_DRS_CaseName DEV],'select * from CaseName'
> ) where CaseNum='PROD007586'
>
> Server: Msg 7390, Level 16, State 1, Line 1
> The requested operation could not be performed because the OLE DB
> provider 'MSDASQL' does not support the required transaction interface.
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::QueryInterface
> returned 0x80004002].
>

[Back to original message]