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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]> > > 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 > > [email protected] > > http://ns3.123.co.nz/mailman/listinfo/delphi > > _______________________________________________ > Delphi mailing list > [email protected] > http://ns3.123.co.nz/mailman/listinfo/delphi > _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
