<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=656104702-02092005><FONT face=Arial
color=#0000ff>Sounds like codesite is what you want:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=656104702-02092005><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=656104702-02092005><FONT face=Arial
color=#0000ff><A
href="http://www.raize.com/DevTools/CodeSite/Default.asp">http://www.raize.com/DevTools/CodeSite/Default.asp</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=656104702-02092005><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><FONT
size=2>Regards<BR><BR>Sean<BR>-------------------------<BR>Sean
Cross<BR>CRM<BR>06 835 5868<BR>021 270 3466 </FONT></DIV>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> delphi-bounces@ns3.123.co.nz
[mailto:delphi-bounces@ns3.123.co.nz] <B>On Behalf Of </B>Robert
Wilson<BR><B>Sent:</B> Friday, 2 September 2005 11:14 a.m.<BR><B>To:</B> NZ
Borland Developers Group - Delphi List<BR><B>Subject:</B> Re: [DUG]
DataSnap/Midas App Server Error<BR></FONT><BR></DIV>
<DIV></DIV><BR><FONT face=sans-serif size=2>Hi Stacey</FONT> <BR><BR><FONT
face=sans-serif size=2>We are experiencing the same issues with a similar
multi-tiered system using datasnap/midas and were actually just discussing
this issue when these postings came through. </FONT><BR><FONT face=sans-serif
size=2>Until now we have been using e-mail messages as a means of trying to
locate problems, but obviously have to limit the number of messages sent so it
is not always catching the issues. We were just kicking around the same basic
idea that Dave Jollie replied with and think that this would be the best
solution, we curently have the Server app with the ability to run in debug
mode "where messages are sent" or standard mode " no messages".
</FONT><BR><FONT face=sans-serif size=2>It is now just a matter of finding the
actual time to retro fit to existing code..</FONT> <BR><FONT face=sans-serif
size=2>But will certainly let you know if we find anything obvious...</FONT>
<BR><BR><FONT face=sans-serif size=2>Cheers</FONT> <BR><FONT face=sans-serif
size=2>Robert Wilson<BR></FONT><BR><BR><BR>
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD>
<TD><FONT face=sans-serif size=1><B>"Stacey Verner"
<stacey@cjntech.co.nz></B></FONT> <BR><FONT face=sans-serif
size=1>Sent by: delphi-bounces@ns3.123.co.nz</FONT>
<P><FONT face=sans-serif size=1>02/09/2005 09:48 a.m.</FONT> <BR><FONT
face=sans-serif size=1>Please respond to NZ Borland Developers Group -
Delphi List</FONT> <BR></P>
<TD><FONT face=Arial size=1> </FONT><BR><FONT
face=sans-serif size=1> To:
"NZ Borland Developers Group - Delphi List"
<delphi@ns3.123.co.nz></FONT> <BR><FONT face=sans-serif
size=1> cc:
</FONT> <BR><FONT face=sans-serif size=1>
Subject: [DUG] DataSnap/Midas App
Server Error</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT face=Arial size=2>We
have an DataSnap/Midas app server which fails randomly.</FONT> <BR><FONT
face="Times New Roman" size=3> </FONT> <BR><FONT face=Arial size=2>We
can't make it happen no matter how hard we try, but it happens fairly
regularly on our production machine.</FONT> <BR><FONT face="Times New Roman"
size=3> </FONT> <BR><FONT face=Arial size=2>A little bit of info on the
app and app server:</FONT>
<UL>
<LI><FONT face=Arial size=2>The applicaiton is a normal database
application.</FONT>
<LI><FONT face=Arial size=2>The application also needs to get information
from a settings (metadata) database such as:</FONT>
<UL>
<LI><FONT face=Arial size=2>Which databases they have access to</FONT>
<LI><FONT face=Arial size=2>What permissions they have on the database
etc</FONT></LI></UL>
<UL>
<LI><FONT face=Arial size=2>Instead of connecting directly to the settings
database we use the app server which shares one database connection
between all clients.</FONT>
<UL>
<LI><FONT face=Arial size=2>This means that there is one database
connection for each application instead of 2 which reduces licencing
costs</FONT></LI></UL>
<UL>
<LI><FONT face=Arial size=2>We use the borland socket server and a
socket connection to connect to the app server.</FONT>
<UL>
<LI><FONT face=Arial size=2>When we used a normal DCOM connection each
client got its own copy of the app server, so the settings database
connection is not shared and in effect each application had two
connections to the database.</FONT> <BR><FONT face=Arial
size=2>Sometimes the app server locks up and the clients can't
connect.</FONT> <BR><FONT face="Times New Roman" size=3> </FONT>
<BR><FONT face=Arial size=2>We have a work around that will try app
servers on other machines if this fails which works OK, but if it
never gets a connection the all sorts of odd things happen.</FONT>
<BR><FONT face="Times New Roman" size=3> </FONT> <BR><FONT
face=Arial size=2>Firstly, does anyone have any thoughts on this.
Debug ideas etc?</FONT> <BR><FONT face=Arial size=2>Secondly, when the
connection to the app server fails it takes forever (minutes) to
return no matter what I set the socket connection timeout to.</FONT>
<BR><FONT face="Times New Roman" size=3> </FONT> <BR><FONT
face=Arial size=2>Thanks</FONT> <BR><FONT face="Times New Roman"
size=3> </FONT> <BR><FONT face=Arial size=2>Stacey</FONT>
<BR><FONT face="Times New Roman" size=3> </FONT> <BR><FONT
face="Courier New" size=2>Stacey Verner
Ph: +64-9-4154790<BR>Software Developer
Fax: +64-9-4154791<BR>
DDI: +64-9-4154797<BR>CJN Technologies Ltd.
Email: </FONT><A href="mailto:stacey@cjntech.co.nz"><FONT
face="Courier New" color=blue
size=2><U>stacey@cjntech.co.nz</U></FONT></A><FONT face="Courier New"
size=2><BR>PO Box 302-278, North Harbour, Auckland 1330, New
Zealand<BR>12 Piermark Drive, North Harbour, Auckland, New
Zealand<BR>Visit our website at </FONT><A
href="http://www.cjntech.co.nz/"><FONT face="Courier New" color=blue
size=2><U>http://www.cjntech.co.nz/</U></FONT></A><FONT
face="Courier New" size=2> </FONT><BR><FONT face="Times New Roman"
size=3> </FONT><FONT face="Courier New"
size=2>_______________________________________________<BR>Delphi
mailing
list<BR>Delphi@ns3.123.co.nz<BR>http://ns3.123.co.nz/mailman/listinfo/delphi<BR></FONT><BR><BR></LI></UL></LI></UL></LI></UL></LI></UL>
<HR>
<STRONG><FONT color=#ff0000>Attention: </FONT></STRONG><BR>Disclaimer:
<P>The information in this electronic mail message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
Internet electronic mail message by anyone else is unauthorised. </P>
<P>If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it is
prohibited and may be unlawful. <BR>If you have received this e-mail by
mistake please call the sender immediately on 09 415 4747 and erase the
original message and any attachments.</P>
<P>Cellular Cellnet (NZ) Ltd accepts no responsibility for any effects this
email message or attachments has on the recipient network or computer system.
<HR>
<P></P></BLOCKQUOTE></BODY></HTML>