Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 4 of 4 total |
Error #11280 Syntax |
Wed, Jun 28 2006 1:59 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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. << 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 |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |