TSoapConnection db error

Article View: borland.public.delphi.database

Article #171

Back to borland.public.delphi.database Previous Next

#171

From: Maarten
Date: Thu, 15 Nov 2007 18:24

29 lines
2072 bytes

Hi,

I have made an application (3-tier) where a remote PC connects to a 
webservice with a database using soap. (connection is a vodafone UMTS 
1.8MBps)
For this I use a TSoapConnection - TClientDataSet - TDataSource 
construction.

                                cds.Edit;
                                cds.FieldByName('IN_PROGRESS').Value := 
True;
                                cds.Post;

                                if cds.ApplyUpdates(-1) > 0 then
                                begin
                                  ShowMessage('Update Failed');
                                end;

(cds is a TClientDataSet)

In this situation, using the ApplyUpdates always results in a Database 
Timeout error.
Since loading the table is quick, I assume the problem is not the network 
performance.
When I test this on a local network however, everything works just fine.

Can anyone help me on this?
Regards,
Martin

Technical Details

Message-ID: <473c8ed7$0$90431$dbd41001@news.wanadoo.nl>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!feeder.news-service.com!news2.euro.net!postnews2.euro.net!news.wanadoo.nl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 115d96,402498b3164ca777,start
X-Google-Attributes: gid115d96,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!feeder.news-service.com!news2.euro.net!postnews2.euro.net!news.wanadoo.nl!not-for-mail
From: "Maarten" <m.roest@alphatronmarine.nl>
Newsgroups: borland.public.delphi.database
Subject: TSoapConnection db error
Date: Thu, 15 Nov 2007 19:24:20 +0100
MIME-Version: 1.0
Content-Type: text/plain;
 format=flowed;
 charset="iso-8859-1";
 reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
Lines: 31
Message-ID: <473c8ed7$0$90431$dbd41001@news.wanadoo.nl>
Organization: Wanadoo
NNTP-Posting-Date: 15 Nov 2007 18:24:23 GMT
NNTP-Posting-Host: s55911810.adsl.wanadoo.nl
X-Trace: DXC=E@eKT9U`TGk@nVBHFc\BfiCkgDnQUcVJjIGOIkGLNKQgB10aNf:EW7eBDDROA;Dm6cbliZ7bLh10`i\GPVIiReCem77ZcQ4:C>l?_g6d]\PjKl
X-Complaints-To: abuse@wanadoo.nl