Problems running Delphi/Interbase application on Windows 2000 1

[reisende]

Hi all,

We are having a very strange problem and I was wondering if anyone here had any insight.

We have developed a Delphi application which stores data to an Interbase database.

Everything has worked fine in testing, but not when we attempt to move it into production.

Here is some background.

We store our applications (.exe's) on a dedicated server on our network which is mapped via X: drive. In order for our field locations to access the applications we use Citrix. Each field user effectively connects to one of our five Citrix servers and runs the application form there.

The Interbase database is also hosted on the X: drive and we are able to connect to it fine in Delphi data module by using this connection string:

10.8.1.2:c:\daily_tracking\data\DAILY_TRACKING.gdb

Our Citrix servers run Windows 2000 server. The application runs fine on our XP and 98 boxes, but will fail when we try to run it on one of the 2000 servers.

Here is what happens:

We know that the program fails when attempting to create the data module that contains our Interbase database. We have stepped through the Application creation process like so:

ShowMessage('Step 13');
Application.CreateForm(Tdm_tracking, dm_tracking);
ShowMessage('Step 14');
Application.CreateForm(Tdm_global_numbers, dm_global_numbers);
ShowMessage('Step 15');

The application will fail on Windows 2000 after step 13 is reached every time.

We have tried building the application in three different Delphi versions and have recieved the same failure each time.

Is this an Interbase limitation? Windows 2000? Citrix?

Any ideas or theories will be greatly appreciated.

Thanks.

 

[svanels]

Looks like when creating the datamodule, tables/queries or database can not connect to the Interbase Server.

The database must reside on the same machine as the interbase server. Shared drives are not recommended.

Is the server name hard-coded in the application?

When you installed the Interbase Server on the Citrix Server, where you able to connect with the SQL-Explorer to the database, after creating an alias?

Check out also

Interbase Installation Question
thread756-933784



Steven van Els
SAvanEls@cq-link.sr

 

[Pikkunero]

I'm thinking the same as svanels. I had once a similar problem. I added support for Interbase to my application server.

Everything went well until my client tried to execute the application server on their server.

The problem simply was that They had no interbase installed on the server. The database was on a different server so all they needed to do was to install interbase client. It is needed on the same machine where the executable is executed.

 

[reisende]

Thanks for the replies guys. We managed to put the client on each of the servers and now it is working. I thought that we'd only need the client (and therefore the server) on the machine that actually hosted the application, but I guess I wrong.

 

[svanels]

You don't need to put the application on a shared drive, this could create other problems.
Just put your executable, together with the interbase client ,and if you are working with the BDE, also de Borland Database engine on any computer you want to use. In case of an upgrade of the executable, just copy the new file to its destination.

Steven van Els
SAvanEls@cq-link.sr