[DUG] DataSnap/Midas App Server Error

[Stacey Verner]

The socked server is version 6.0 (6.0.6.240). It's the one that comes
with Delphi 6 Service Pack 2.

Stacey

> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz 
> [mailto:delphi-bounces at ns3.123.co.nz] On Behalf Of Paul McKenzie
> Sent: Friday, 2 September 2005 10:23
> To: NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] DataSnap/Midas App Server Error
> 
> Ok, there goes my idea about old version...
> Is the SocketServer version 9 also?
> When it dies are the any event log events?
> 
> Regards
> Paul McKenzie
> Wellington
> New Zealand
> 
> 
> Stacey Verner wrote:
> > We are using Delphi 6 service Pack 2.
> > 
> > The versions in midas.dll say 9.0 and 9.0.1761.24408.
> > 
> > Stacey
> > 
> > 
> >>-----Original Message-----
> >>From: delphi-bounces at ns3.123.co.nz
> >>[mailto:delphi-bounces at ns3.123.co.nz] On Behalf Of Paul McKenzie
> >>Sent: Friday, 2 September 2005 9:58
> >>To: NZ Borland Developers Group - Delphi List
> >>Subject: Re: [DUG] DataSnap/Midas App Server Error
> >>
> >>Which version of MIDAS are you using ?
> >>
> >>Regards
> >>Paul McKenzie
> >>Wellington
> >>New Zealand
> >>
> >>
> >>Stacey Verner wrote:
> >>
> >>>We have an DataSnap/Midas app server which fails randomly.
> >>> 
> >>>We can't make it happen no matter how hard we try, but it happens 
> >>>fairly regularly on our production machine.
> >>> 
> >>>A little bit of info on the app and app server:
> >>>
> >>>*	The applicaiton is a normal database application.
> >>>*	The application also needs to get information from a settings
> >>>(metadata) database such as:
> >>>
> >>>	*	Which databases they have access to
> >>>	*	What permissions they have on the database etc
> >>>
> >>>*	Instead of connecting directly to the settings database we use
> >>>the app server which shares one database connection between
> >>
> >>all clients.
> >>
> >>>	*	This means that there is one database connection for
> >>>each application instead of 2 which reduces licencing costs
> >>>
> >>>*	We use the borland socket server and a socket connection to
> >>>connect to the app server.
> >>>
> >>>	*	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.
> >>>
> >>>Sometimes the app server locks up and the clients can't connect.
> >>> 
> >>>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.
> >>> 
> >>>Firstly, does anyone have any thoughts on this. Debug ideas etc?
> >>>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.
> >>> 
> >>>Thanks
> >>> 
> >>>Stacey
> >>> 
> >>>Stacey Verner             Ph:   +64-9-4154790
> >>>Software Developer        Fax:  +64-9-4154791
> >>>                          DDI:  +64-9-4154797
> >>>CJN Technologies Ltd.     Email: stacey at cjntech.co.nz
> >>><mailto:stacey at cjntech.co.nz>
> >>>PO Box 302-278, North Harbour, Auckland 1330, New Zealand
> >>>12 Piermark Drive, North Harbour, Auckland, New Zealand Visit our 
> >>>website at http://www.cjntech.co.nz/ <http://www.cjntech.co.nz/>
> >>> 
> >>>
> >>>
> >>>
> >>>
> >>
> >>------------------------------------------------------------
> ----------
> >>
> >>>--
> >>>
> >>>_______________________________________________
> >>>Delphi mailing list
> >>>Delphi at ns3.123.co.nz
> >>>http://ns3.123.co.nz/mailman/listinfo/delphi
> >>
> >>_______________________________________________
> >>Delphi mailing list
> >>Delphi at ns3.123.co.nz
> >>http://ns3.123.co.nz/mailman/listinfo/delphi
> >>
> > 
> > 
> > _______________________________________________
> > Delphi mailing list
> > Delphi at ns3.123.co.nz
> > http://ns3.123.co.nz/mailman/listinfo/delphi
> > 
> > 
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>