[DUG] DataSnap/Midas App Server Error

[Stacey Verner]

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
>