We help IT Professionals succeed at work.

Interbase Firebird cpnflicts!!

rthriller
rthriller asked
on
Medium Priority
888 Views
Last Modified: 2013-12-09
Hello!

I installed BDS2006 once but I installed Interbase and firebird many many times and unistalled them many many times and now I cannot uses neither of the engines.

Help please!
Comment
Watch Question

kacorretired

Commented:
Try as follows:
1. uninstall Interbase or Firebird then delete every Interbase and Firebird registration from the registry
2. search and delete every copy of gds32.dll
3. uninstall then reinstall BDS 2006
4. install IB or FB.
Normally IB and FB use the port 3050 for communication. You can use other port too (for example 3051) e.g. you can use the same time FB and IB but I am not sure. I don't know whether two gds32.dll's disturbe each other or not, how is possible to make difference between them etc.... Probably NickUpson could help you more. I have no experience in this area.
I hope this help
wbr
Janos

Nick UpsonPrincipal Operations Engineer
CERTIFIED EXPERT

Commented:
Kacor is correct, both interbase & firebird use port 3050 for communication (lets ignore events for now)
you can have both working on the machine by installing say firebird, edit the config firebird.conf to change the port number & restart
then install interbase. They will both work fine BUT you will have to specify the firebird port number in the connection string "localhost:c:\files\mydb.fdb::3060" from memory (assume set to port 3060).

The gds32.dll problem shouldn't occur as firebird installs it's dll under a different name unless you tell it to install under the old name during the install process

Author

Commented:
This solution may work, and I could also reinstall windows from scratch. What I wanted to know is how other software like IBEasy, IBExpert, Interbase&Firebird Development Studio and EMS still have connection to firebird but not my already compiled Delphi applications. How de these programs do to access let say firebird in these conditions?

Thanks!
Nick UpsonPrincipal Operations Engineer
CERTIFIED EXPERT

Commented:
IT's all down to the connection string used, the tools you list have one and so does your delphi application

Author

Commented:
is there a way to "scan" and get a list of running interbase and/or firebird server and their ports and then build the connection string at runtime?
Nick UpsonPrincipal Operations Engineer
CERTIFIED EXPERT

Commented:
none I know of, you would also need to know which one to use to access a given database. They cannot both access the same database file and doing so at the same time from both servers would be a fast route to corruption

Author

Commented:
I think the best solution for me is to set a different port number and specify it in the connection string.

But your way doing it is not working for me.

using a TIBDatabase component    localhost:c:\files\mydb.fdb::3060   gives me this error :

I/O error for file "localhost:c:\files\mydb.fdb::3060" Error while trying to open file. Paramètre incorrect.

but it works without specifying the port :(
Nick UpsonPrincipal Operations Engineer
CERTIFIED EXPERT

Commented:
which one works, interbase or firebird, with the .fdb filename you need it to be firebird

which one do you want to run on port 3050 the default and which on some other port say 3060
if you want firebird on 3060 edit the firebird.conf to set the port number and reboot

Author

Commented:
Hmmm, sorry, I did not ask my question correctly.

Suppose I have both interbase and firebird running on diffrent ports. Let say interbase port 3050 and firebird port 3060.

How to force my program to use firebird and ignore interbase?
Nick UpsonPrincipal Operations Engineer
CERTIFIED EXPERT

Commented:
to force the program to use firebird you refer to the firebird port (3060 above) in the connection string

Author

Commented:
Nick

I agree with you about that but how?

I tried localhost:c:\files\mydb.fdb::3060  (of course using my own db path) but it did not work and I got an error message saying :

I/O error for file "localhost:c:\files\mydb.fdb::3060" Error while trying to open file. Paramètre incorrect.

Thanks
Principal Operations Engineer
CERTIFIED EXPERT
Commented:
are you sure that firebird is running on 3060, please show the relavent part of firebird.conf

I may have made a typo, please try this format        localhost/3051:c:\files\mydb.fdb

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
It is working

Thank you
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.