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

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote in message
news:447c75d7$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"Christian Dubois" <cdubois@xxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:447c68ff$1@xxxxxxxxxxxxxxxxxxxxxxxxx
1. I got exactly the same error message even if I remove "With
View_Metadata".
Sure you will, since this option has no effect for serverside cursors and
thats why error which you are observing is happening.

2. I cannot use a client-side cursor because the original tables has more
than 900 000 rows.
3. I cannot use a TADOCommand because I don't want to execute a specific
query, I want to Edit a dataset, allow user to change fields, and then
post the record.
So you think that user will be able manually locate necessary record in
900 000 rows and edit them?

I cannot explain it simply, but you can believe me: Sometime I need to
browse througt 900 000 (ex : to export data). In others cases, I need to
retrieve specific rows (by applying "where statement"), Edit fields and post
data.


I still don't understand why is it working with an ODBC driver and not
with an OLE DB driver. Microsoft advise me that is it a client app issue
(not SQL Server).

I really need to solve this issue, any help would be appreciate.
IMHO you really need to resort yours design. Microsoft just had given you
useless answer with no answer at all. Probably you should ask ADO or OLEDB
drivers developers, but not MS SQL server developers since issue really
happens on a client side but still in MS stuff.

Microsoft cannot help me because he can't reproduce the problem. Also,
similar code writen in C# with the SQLOLEDB driver is working. So Microsoft
said that this is a Delphi issue. Is it the reason why I am posting this
query here.

Did you know how I can contact ADO or OLEDB drivers developers?

Thank your for helping.
Christian


.

Relevant Pages

  • SecurityFocus Microsoft Newsletter #49
    ... Subject: SecurityFocus Microsoft Newsletter #49 ... Microsoft Windows NNTP Denial of Service Vulnerability ... Microsoft IIS SSI Buffer Overrun Privelege Elevation Vulnerability ... Microsoft ISA Server H.323 Memory Leak Denial of Service... ...
    (Focus-Microsoft)
  • Re: AD management snap in cannot find DC (netdiag /v workstation)
    ... The name.local entries are used by my apache server to implement ... Attr: subschemaSubentry ... Owner of the binding path: ... Component Name: Client for Microsoft Networks ...
    (microsoft.public.windows.server.active_directory)
  • Re: IIS Start up errors
    ... provide the detailed steps to reinstall the IIS server in SBS 2003 server. ... For example, programs such as Microsoft ... In the Currently installed programs list, click Windows Small Business ...
    (microsoft.public.windows.server.sbs)
  • Re: Cant see performance report, etc. SBS2003
    ... Windows Performance monitor component changes the ... However, for "OpenSSH Server", you need to ensure it started, or set ... click to check the "Hide All Microsoft ... Reinstall Monitoring component: ...
    (microsoft.public.windows.server.sbs)
  • Re: Cant logon from workstation as Administrator
    ... server box and let me know if there is any problem related to the issue. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... be able to logon using ANY accounts from that workstation. ...
    (microsoft.public.windows.server.sbs)