Good day
-=0-=0-=0=0
This is a server that we have written our selves that will on bussines
events (adding a account for instance) be notified by the client via a custom
socket protocol that runs on port 4220 and then the server connects as a
client to the database and does whatever is registered to do on that event.

This is a all custom thing , but in the end it is only a socket
notification to the server program that the event has trigger and then the
server will act on it as a client
again. So in short both programs connects to the database as a client
database.

The reason we did this is that the program in D3 was written by contractors
who used a lot of freeware components and we cannot find them to upgrade ,
and the code is
hard to convert to NATIVE interbase components , so we are using BDE. This
the trigger server idea came to play.

I hope this gives more information on the subject

Thanks

Johannes


At 16:05 04/03/2003 +1100, Alan McDonald wrote:

>What do you mean by a server application? Is it a 3 tier application with a
>middle tier on the same box? OR by server application do you mean another
>client running on the server? Is the D3 Client talking to the D5 application
>on the server which is talking to the IB server? When you say business
>trigger o do you mena an IB trigger? Why do you say "business trigger" is
>this something special to your applciation?
>
>I think you need to be clearer
>Alan
>
>-----Original Message-----
>From: Johannes Pretorius [mailto:johannes@...]
>Sent: Tuesday, 4 March 2003 3:41 PM
>To: ib-support@yahoogroups.com
>Subject: [ib-support] Interbase connection problem. - MORE INFO
>
>
>Good day
>\-\=-\=-=\-\=-
>
>I have sat down and looked at the source of the Delphi program that works
>with the database as the idea that the trigger on the database is giving a
>problem does not
>make sense and this is the result.
>
>I have a Delphi server program and a Delphi client program that runs on the
>same database. Client is Delphi 3 and Server is Delphi 5.
>The client program starts a business trigger and the server then tries to
>act on this trigger, but its connection that is setup in the BDE as
>localhost:d:\db\promed.gdb is then dropped. in the sense that I get a 10054
>error locally at the server. It seems this is happening at a other client
>also
>but from the client machines also. Will the server program really have a
>problem if there is a problem with the networkcard as locahost is the
>loopback device that
>is 127.0.0.1 ???
>
>Any help will be apreciated.
>
>Interbase version : 5.6
>Database sizes from : 250 - 830 MB
>
>Other strange events :
>
>When trying to get the connection user list of the interbase database I get
>a connection lost to database. After that the server crashes and need to be
>restarted.
>
>PS : Has anybody noticed that if the alias via BDE to the interbase
>database is <servername>:d\db\promed.gdb (Notice there is no : after the
>first d) and there is a network share for D. Then SOMETIMES on some
>networks there is a problem that if this method of connection WORKS then
>the datbase gets corrupt FAR bejond repair. I get the Idea that it uses
>network cache or something and is out of sync with the machines OS cache.
>Very odd. ??? Thanks
>
>
>Thanks for any help in advance
>
>
>
>Johannes Pretorius
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/