[DUG] DataSnap/Midas App Server Error

[Paul McKenzie]

We had various problems with our AppServer using the MIDAS and SocketServer that came with D7.
We now use both MIDAS 9 and SocketServer 9. Seems alot more stable!

Regards
Paul McKenzie
Wellington
New Zealand


Stacey Verner wrote:
> 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
>>
> 
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
>