[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2005-04-06
9
Medium Priority
?
346 Views
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.

Cherrel
0
Comment
9 Comments
 
LVL 12

Expert Comment

by:esoftbg
ID: 13759916
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:
'\\Computer_Name\Database_Path\Database_Name.GDB'
it is incorrect

Try to use like following format:
'Computer_Name:C:\Database_Path\Database_Name.GDB'
or
'Computer_Name:C:Database_Path\Database_Name.GDB'

Best Regards,
Emil
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 13759925
I think, you may use this format too:
'Local_IP_Address:C:\Database_Path\Database_Name.GDB'
0
 

Author Comment

by:cuautomatiseringsdiensten
ID: 13761515
Emil,

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?

Regards,

Cherrel
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 12

Expert Comment

by:esoftbg
ID: 13782669
Cherrel,
I am not experienced enough in this stuff about the Data Acces components .... I am using only  Interbase components.
Sorry.
0
 
LVL 12

Expert Comment

by:Ivanov_G
ID: 13788755
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 ?
0
 

Author Comment

by:cuautomatiseringsdiensten
ID: 13823520
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.

Thanks,

Cherrel
0
 

Author Comment

by:cuautomatiseringsdiensten
ID: 13823550
Hi everyone,

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

Regards,

Cherrel
0
 
LVL 14

Expert Comment

by:cwwkie
ID: 16394977
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.

cwwkie
EE Cleanup Volunteer
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 16416054
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Integration Management Part 2
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month18 days, 22 hours left to enroll

834 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