Programs freezes when trying to connect remotely to Firebird from an delphi 7 midas-application

Posted on 2005-04-06
Last Modified: 2010-04-05
Hi colleagues,

I build an midas application with Delphi 7 using some of the included interbase components which are IBTransaction, IBDatabase, IBTable and IBQuery. As a database I'm using FireBird. To communicate the one with the other I use the following Delphi's Data Acces components, ClientDataSet, the DataSetProvider and the DataSource all of the Data Acces tab.

Running the application locally works fine, but if I put the database elsewhere in the network (active directory), running the application will freeze everything on the 'db-machine'/server.
I made a form for the application server to tell me the amount of current connections to the application server. If I start the client application on the 'db-machine' and then the one on the client the amount will be shown correctly, so it connects to the application server, but only when I have first started the client application on the 'db-machine' otherwise it won't it will say that the database is unavailable. In all sircunstances it is not opening the client application for work, it won't pass trough the application's login-form.

Note: I'm using a Delphi version which is not registered and FireBird can it be that my issue has to do with licencing?

I took the following steps in order to get the whole thing running:

A) Server/db-machine:
1. Installed the FireBird server on the 'db-machine'
2. Using IBAdmin4 I configured the server for tcp/ip and created the user to be owner of the db and the created the database
3. Made an ini file containing the database_path and servername('db-machine') in c:\windows\system32
4. Ran the application server (app serv and db serv on the same machine) to register the dcom
5. gain user access to the app server using dcomcnfg

B) Client machine:
1. client exe thogether with it's ini file (connection=dcom and host=db-machine)
2. Copied the midas.dll to the c:\windows\system32 and register it

I think I made all the correct steps, please correct me if I'm wrong.
This is very urgent due to the fact that I'm in the delivery stadium.....

I hope someone can help me solve this issue I will appreciate it very much, thanks.

    LVL 12

    Expert Comment

    Excuse me for the delay (The reason is I changed my e-mail address for messages from experts-exchange):
    > 3. Made an ini file containing the database_path and servername('db-machine') in c:\windows\system32

    may be the format of the database_path you save in the .ini file is wrong, so FireBird can not use it ....
    If you use the Microsoft format about the Server machine as:
    it is incorrect

    Try to use like following format:

    Best Regards,
    LVL 12

    Expert Comment

    I think, you may use this format too:

    Author Comment


    Thanks for your reaction, I was allready thinking that I did something wrong, because I got no reactions.

    I am able to get the program working remotely, but having that one running and running a second one that in this case is installed locally the last one freezes. It seems that the system is not allowing multi-user. Is it possible that this has someting to do with licensing?


    LVL 12

    Expert Comment

    I am not experienced enough in this stuff about the Data Acces components .... I am using only  Interbase components.
    LVL 12

    Expert Comment

    First of all you don't mention where you use the MIDAS layer, I mean how your server is made - COM, MTS COM+, ... ?

    I makes sence if it is remote component, otherwise you don't have to use MIDAS, because as far as I remember, if requires some licence you use it in client-server environment.

    Where you put TDataSetProvider, in what type of application ?

    Author Comment

    Emil and Ivanov,

    Thank you both for your comments.
    I had work with the IBcomponents from IboObjects in the past, because of the fact that IBX is free I try to use it, but I went back to the IBcomponents and it works fine know.



    Author Comment

    Hi everyone,

    I would like to close this question. Can somebody tell me how to?


    LVL 14

    Expert Comment

    No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

    I will leave the following recommendation for this question in the Cleanup topic area:
       PAQ - Refund

    Any objections should be posted here in the next 4 days. After that time, the question will be closed.

    EE Cleanup Volunteer
    LVL 1

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
    In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now