Installing Interbase 5.5 and Firebird 2.0 at the same machine

Posted on 2008-10-24
Last Modified: 2013-12-09
Is it possible to have Interbase 5.5 and Firebird 2.0 installed at the same machine ? so that I could toggle between them when I want to use Interbase 5.5 or toggle again when I need Firebird 2.0 ? And the way to toggle them ?
Question by:ivylnm
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Accepted Solution

dprochownik earned 50 total points
ID: 22795146
You can do that in two ways:

  1. As I kwow, firebirdClient.dll has down compatibility with gds32.dll. I'm not sure if this is true for Firebird 5.5, but if yes, than you can install both of them on the same machine (Interbase first and then Firebird), rename FirebirdClient.dll to gds32.dll and use it to override gds32.dll installed by Interbase, propably in c:\windows\System32

    Next you have to configure for example firebird to use different port than 3050 which is also used by Interbase. You can do tham by modyfi Firebird.conf in firebird direvtory.
    Chenge line:
    #RemoteServicePort = 3050
    by (for example)
    RemoteServicePort = 3040
    And restart firebird.
    Now when you want to connect to databese localhost:c:\mydatabase.gdb using Interbase, you can do that as always putting database name to localhost:c:\mydatabase.gdb, but when you want connect using firebird, you have to put database name as localhost/3040:c:\mydatabase.gdb

  2. In second way you are doing exacly the same steps as in first one, but you don't change port number for firebird.
    Against that you are setting firebird or Interbase service in Windows to not automatic start.
    To start Firebird you are writing some .bat file, containing:
    NET START "FirebirdGuardianDefaultInstance"
    NET START "FirebirdServerDefaultInstance"

    I'm not sure about Interbase service name. If it is not GDS_DB, than replace it by proper value.

    To start Interbase just use another .bat file containing
    NET STOP "FirebirdGuardianDefaultInstance"
    NET STOP "FirebirdServerDefaultInstance"

    In this way, you are connecting from application with firebird and Interbase with the same database file name (without different ports), but you have to be sure that, they are not listenin on the same port in the same time. One of them have to be disabled at windows start, and you have to use .bat files to disable/enable proper services.
LVL 19

Assisted Solution

NickUpson earned 30 total points
ID: 22796099
agreed with previous description, minor points

it's fbclient.dll not firebirdClient.dll

don't use a filename that has a .gdb suffix, windows takes backups of it, use .fdb for firebird and .ib7 for interbase.

interbase 5.5 is very, very, old, it predates the interbase/firebird split and was never designed to work on XP so you may have issues with it.

firebird 2.0 has stricter rules about some syntax and some different reserved words since interbase 5.5 days

Expert Comment

ID: 22801992
I will only add, that if you will choose first of described method you can also modify
file by adding:
fb20             3040/tcp    firebird20             #Firebird 2.0 server
Interbase    3050/tcp    firebird15             #Interbase 5.5 server

if you do that, you can access to database by passing file name:


depends on which one SQL server you want use


Expert Comment

ID: 22801997
There should be:

fb20             3040/tcp    firebird20             #Firebird 2.0 server
Interbase    3050/tcp    Interbase55        #Interbase 5.5 server

Sorry for mistake
I had copy that from my own services file (I'm using Firebird 1.5 and 2.0 on the same machine)

Featured Post

 Database Backup and Recovery Best Practices

Join Percona’s, Architect, Manjot Singh as he presents Database Backup and Recovery Best Practices (with a Focus on MySQL) on Thursday, July 27, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). In the case of a failure, do you know how long it will take to restore your database?

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

623 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