If you change the IP in the EDBSrvr to a bad IP, close the server and
then reopen it you can't start the server until you fix the IP in
edbsrvr.ini (in Vista at least). The server should allow you to change
the IP address without having to edit edbsrvr.ini manually.

Michael,

<< If you change the IP in the EDBSrvr to a bad IP, close the server and
then reopen it you can't start the server until you fix the IP in
edbsrvr.ini (in Vista at least). The server should allow you to change the
IP address without having to edit edbsrvr.ini manually. >>

Are you running the server as an application, or a service ?  If you're
running the server as an application, then just right-click on the system
tray icon, click on Restore, and then click on the Edit Server Options to
bring up the server configuration dialog.  You can change the IP address on
the second page - Connections.

--
Tim Young
Elevate Software
www.elevatesoft.com

On Tue, 1 Dec 2009 09:51:49 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

>Michael,
>
><< If you change the IP in the EDBSrvr to a bad IP, close the server and
>then reopen it you can't start the server until you fix the IP in
>edbsrvr.ini (in Vista at least). The server should allow you to change the
>IP address without having to edit edbsrvr.ini manually. >>
>
>Are you running the server as an application, or a service ?  If you're
>running the server as an application, then just right-click on the system
>tray icon, click on Restore, and then click on the Edit Server Options to
>bring up the server configuration dialog.  You can change the IP address on
>the second page - Connections.

I'm running as an application. There is no icon as the server never
starts.

On Mon, 30 Nov 2009 21:58:37 -0800, Michael Fullerton
<fullerm@cybermatrix.com> wrote:

>If you change the IP in the EDBSrvr to a bad IP, close the server and
>then reopen it you can't start the server until you fix the IP in
>edbsrvr.ini (in Vista at least). The server should allow you to change
>the IP address without having to edit edbsrvr.ini manually.

I understand this a bit better now. The problem is actually due to
some code I added to the server to change the database path. In
TMainForm.Initialize I have this code near the bottom:

  with Session do begin
   LoginPassword:= 'EDBDefault';
   LoginUser:= 'Administrator';
   Execute('ALTER DATABASE "MyDB" PATH
'+Engine.QuotedSQLStr(ExtractFilePath(Application.ExeName)));
  end;

This works fine if the IP is correct but the ALTER DATABASE line
causes the server to crash if the IP isn't correct.

Michael,

<< I understand this a bit better now. The problem is actually due to some
code I added to the server to change the database path. In
TMainForm.Initialize I have this code near the bottom:

  with Session do begin
   LoginPassword:= 'EDBDefault';
   LoginUser:= 'Administrator';
   Execute('ALTER DATABASE "MyDB" PATH
'+Engine.QuotedSQLStr(ExtractFilePath(Application.ExeName)));
  end;

This works fine if the IP is correct but the ALTER DATABASE line causes the
server to crash if the IP isn't correct. >>

Please send me the code that you're using.  You're confusing the IP address
that the server engine binds to for listening vs. the IP address used for a
session to connect to the server, so I'll need to look at the code to see
exactly what is going on.

--
Tim Young
Elevate Software
www.elevatesoft.com

Michael,

You need to put any database access code in the AfterStart event for the
TEDBEngine component.  Your code is causing the engine to attempt to start
again, even after failing to start the first time, and then the resultant
exception is causing the server to crash because it isn't being trapped.
You'll notice that we trap all server exceptions in a try..except block.

Tim Young
Elevate Software
www.elevatesoft.com