|
|
Posted by John Bell on 10/02/05 11:45
Hi
Check out http://tinyurl.com/kj3ow on how to determine how to use 4 part
naming. I am not sure if you need this now
http://www.databasejournal.com/features/mssql/article.php/3462011 but you
may want to check it out.
You may also want to check that this is not a read-only interface, also see
if there is a OLEDB interface available so you don't have to go through
ODBC.
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].
>
Navigation:
[Reply to this message]
|