RE: SQLOLEDB and updatable views with INSTEAD OF triggers

Ok, nobody really bothered to answer, but I figured the problem myself - it
works with client-side cursors and not the server-side.

> Hi,
>
> I have a C++ client application (with MDAC 2.8 SP1) that connects to the SQL
> Server 2000 SP4 using sqloledb provider.
> My database has several updatable views with INSTEAD OF triggers, however
> they are not fired when the data is inserted into the view through OLE DB
> interface. I've got an error message "Cannot insert or update columns from
> multiple tables".
> It works fine with direct queries but not with ole db drivers.
> After reading some documentation I found that the WITH VIEW_METADATA
> statement should be present in the view declaration, however it didn't help
> at all...
> Am I doing something wrong ot this is a known bug in OLE DB? If so, where
> can I get a hotfix, because I'm really stuck with this issue.
>
> Thanks in advance,
> Dmitry
>
.