Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Error #11280 Syntax
Wed, Jun 28 2006 1:59 PMPermanent Link

"Johnnie Norsworthy"
With my new C/S software using DBISAM 4, I am getting the following error at
a customer site:

DBISAM Engine Error # 11280 A connection to the database server at 'xxxxxx'
cannot be established.

I use a system where a computer tries to connect to a local server first,
identified with 'xxxxxx' above, but when that doesn't work, it connects to
an internet server.

All computers at this site default to the internet server after trying the
local connection and I know that works because I can view the internet
server data; there is no local server.

The above message appears to be talking about a local server connection
problem. Does it default to this message format based on Session properties
that I need to change when I switch to internet mode? My code I use to
switch modes is below.

And what is the cause of the problem in the first place? I have
Session.KeepConnections=TRUE, but Session.RemotePing=FALSE.

Thanks!

Johnnie

procedure ApplySecuritySettings(Intranet:Boolean);
begin
 Data.Session.Active := False;
 if Intranet then
 begin
   OfficeSecurityConnection := 1;  // intranet
   Data.Session.RemoteHost := OfficeSecurityStation;
   Data.Session.RemoteAddress := '';
 end
 else
 begin
   OfficeSecurityConnection := 2;  // internet
   Data.Session.RemoteAddress := OfficeSecurityIP;
   Data.Session.RemoteHost := '';
 end;
 Data.Session.RemoteUser := 'user';
 Data.Session.RemotePassword := OfficeSecurityCode;
 Data.Session.RemotePort := OfficeSecurityPort;
end;



Thu, Jun 29 2006 2:48 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Johnnie,

<< The above message appears to be talking about a local server connection
problem. Does it default to this message format based on Session properties
that I need to change when I switch to internet mode? >>

That is the standard error message that DBISAM issues with the 11280 error
when it cannot cannot to a remote database server at the designated IP
address.

<< And what is the cause of the problem in the first place? >>

The problems are usually:

a) A database server is not running at the designated IP address
b) A database server is running at the designated IP address, but:

   1) It is stopped (not listening for incoming connections)
   2) It is started, but not bound to the correct IP address
   3) It is started, bound to the correct IP address, but not bound to the
correct port
   4) It is started, bound to the correct IP address and port, but a
firewall is blocking access to the port

<< I have Session.KeepConnections=TRUE, but Session.RemotePing=FALSE.  >>

Those properties don't have any bearing on establishing connections.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Jun 29 2006 3:33 PMPermanent Link

"Johnnie Norsworthy"
Tim,

Thanks as always for your detailed response. I'm a C/S newbie and have
created a pretty cool system using DBISAM. It allows folks to take their
computers home and still connect to the office database. It does this by
trying the local networks's server computer name first, then it tries across
the internet changing the server information appropriately.

This 11280 message appears to happen *after* a computer has been connected
for a period of time, and the connection is not a local connection, but an
internet connection, so shouldn't the server address be displayed there?

If the computer has not accessed the server in some time is it possible the
session gets closed and then cannot reconnect? I have files that will always
remain open while my program runs.

Where should I trap this exception for diagnosing and presenting a
friendlier message to the end-user?

The office where the server is running has been experiencing some internet
problems, so that can be an issue for some of the bug reports I received.

Thanks mucho,

Johnnie


Fri, Jun 30 2006 4:19 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Johnnie,

<< Thanks as always for your detailed response. I'm a C/S newbie and have
created a pretty cool system using DBISAM. It allows folks to take their
computers home and still connect to the office database. It does this by
trying the local networks's server computer name first, then it tries across
the internet changing the server information appropriately. >>

That *is* cool, and probably very well received by the users. Smiley

<< This 11280 message appears to happen *after* a computer has been
connected for a period of time, and the connection is not a local
connection, but an internet connection, so shouldn't the server address be
displayed there? >>

Yes, the address in the error should be the address that the TDBISAMSession
is using via the RemoteAddress property.  If it isn't, then you're using a
different session or the session's RemoteAddress hasn't been set to what you
think it has been set to.

<< If the computer has not accessed the server in some time is it possible
the session gets closed and then cannot reconnect? I have files that will
always remain open while my program runs. >>

It depends upon whether you have the TDBISAMSession.RemotePing property set
to True or not:

http://www.elevatesoft.com/dbisam4d5_tdbisamsession_remoteping.htm

<< Where should I trap this exception for diagnosing and presenting a
friendlier message to the end-user? >>

The best place would simply be with the Application.OnException global event
handler.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image