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/