Re: Cannot insert or update columns from multiple tables (post #2) Need help please

I already have MDAC 2.8.
Here is what Microsoft said :
----------------------------------------
I am not sure the issue match exactly the KB
(http://support.microsoft.com/?id=835677).
[..]
Based on previous cases, if we can't find any warning or exception
message in the SQL Server trace file, it represents the issue is caused by
client application, not server side issue. Also, since the issue can be
fixed after changing to ODBC Provider, it seems the root cause is on the
Dephi app side.
----------------------------------------

Please be conscient that I don't want to accuse Delphi or Microsoft, I just
want to find someone who can help me solve this issue (Microsoft, Borland,
OLE DB, God, ...)

Thank you for your help
Christian Dubois


"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:nrsp72p7rfld4t52f02dtigun014t2j5kl@xxxxxxxxxx

Here is a really strange thing when I am using SQLOLEDB (Microsoft OLE DB
Provider for SQL Server) to update records from a dataset on a
multi-tables
view containing an "instead of trigger". I am using a server-side cursor
(and I cannot use a client-side cursor in my case).

But if I change the SQL driver to use an ODBD DataSource (Microsoft OLE DB
Provider for ODBC Driver), is it working.

What is the problem with SQLOLEDB and I can I solve this issue?

Your problem seems to fit the description in this document
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B835677
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.

Relevant Pages

  • Critical Alert Update - W32.Slammer
    ... It's not clear if SQL Server 2000 SP1/SP2 includes the ... Microsoft SQL Desktop ... and all applications that install ... >most recent cumulative SQL Server security patch, ...
    (microsoft.public.security)
  • Re: are ado questions allowed here?
    ... Microsoft re MDAC ... This article describes the past, present, and future of Microsoft data ... * OLE DB (including SQL Server OLE DB Provider, ... will be available on the 64-bit Windows operating system. ...
    (comp.databases.ms-access)
  • Re: Critical Alert Update - W32.Slammer
    ... > It's not clear if SQL Server 2000 SP1/SP2 includes the ... > Microsoft SQL Desktop ... >>most recent cumulative SQL Server security patch, ...
    (microsoft.public.security)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Where can I find a DB2 OLE DB provider for SQL Server 2000?
    ... Microsoft OLEDB Provider for DB2 ... SQL Server 2005 Enterprise Edition and Developer Edition. ...
    (microsoft.public.sqlserver.connect)