<!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><SPAN class=768051121-01092005><FONT face=Arial size=2>We have an
DataSnap/Midas app server which fails randomly.</FONT></SPAN></DIV>
<DIV><SPAN class=768051121-01092005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=768051121-01092005><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></SPAN></DIV>
<DIV><SPAN class=768051121-01092005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=768051121-01092005><FONT face=Arial size=2>A little bit of info
on the app and app server:</FONT></SPAN></DIV>
<UL>
<LI><SPAN class=768051121-01092005><FONT face=Arial size=2>The applicaiton is
a normal database application.</FONT></SPAN></LI>
<LI><SPAN class=768051121-01092005><FONT face=Arial size=2>The application
also needs to get information from </FONT></SPAN><SPAN
class=768051121-01092005><FONT face=Arial size=2>a settings (metadata)
database such as:</FONT></SPAN></LI>
<UL>
<LI><SPAN class=768051121-01092005><FONT face=Arial size=2>Which
databases they have access to</FONT></SPAN></LI>
<LI><SPAN class=768051121-01092005><FONT face=Arial size=2>What permissions
they have on the database etc</FONT></SPAN></LI></UL>
<LI><SPAN class=768051121-01092005><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></SPAN></LI>
<UL>
<LI><SPAN class=768051121-01092005><FONT face=Arial size=2>This means that
there is one database connection for each application instead of 2 which
reduces licencing costs</FONT></SPAN></LI></UL>
<LI><SPAN class=768051121-01092005></SPAN><FONT face=Arial size=2><SPAN
class=768051121-01092005>We use the borland socket server and a socket
connection to connect to the app server.</SPAN></FONT></LI>
<UL>
<LI><FONT face=Arial size=2><SPAN class=768051121-01092005>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.</SPAN></FONT></LI></UL></UL>
<DIV><FONT face=Arial size=2><SPAN class=768051121-01092005>Sometimes the app
server locks up and the clients can't connect.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768051121-01092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=768051121-01092005>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768051121-01092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=768051121-01092005>Firstly, does anyone
have any thoughts on this. Debug ideas etc?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=768051121-01092005></SPAN></FONT><FONT
face=Arial size=2><SPAN class=768051121-01092005>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768051121-01092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768051121-01092005>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768051121-01092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768051121-01092005>Stacey</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768051121-01092005></SPAN></FONT> </DIV>
<DIV align=left><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"
size=2>stacey@cjntech.co.nz</FONT></A><BR><FONT face="Courier New" size=2>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"
size=2>http://www.cjntech.co.nz/</FONT></A><FONT face="Courier New" size=2>
</FONT></DIV>
<DIV> </DIV></BODY></HTML>