Is the DataModeler end of life?

[White_Simon]

As far as I can tell there have not been any updates for awhile.
We have recently moved on to Firebird 64 bit projects.

64 bit is not supported? Trying to reverse engineer a Firebird 4 64 bit database we got..

ODS 11.2 is Firebird 2.5 32 bit last version, Since then we have had version 3, 4 and 5.

Your website says it supports Firebird 3 which is ODS 12.

The latest releases of Firebird 4 abd 5 have ODS versions 13 and 13.1

So will we ever be able to use DataModeler with current Firebird database version?

Thanks Simon

[wlandgraf (Wagner Landgraf)]

That message is not related to the bitness of Firebird server, but to the version you are using for the Firebird client.

I believe you should make sure the latest Firebird client (fbclient.dll) is accessible to the Data Modeler.

[White_Simon]

In not sure it has to do with the bitness

I understand that the Firebird client and server architectures are independent of each other when communicating over a network (TCP/IP).

I know that if the 32-bit application is correctly configured to use the corresponding 32-bit Firebird client library, it will connect to and interact with the 64-bit Firebird database server successfully.

I have FB version 4 32 bit and 64 bit clients installed on my development machine.
Locations
64 bit D:\Dev\Firebird\fbclient.dll
32 bit D:\Dev\Firebird32\fbclient.dll

I understand that dw.exe is a 32 bit application
To highlight this i have used sigcheck

//---------------------------------------------
D:\Dev\SigCheck>sigcheck -a "C:\Program Files (x86)\TMSSoftware\Data Modeler\dm.exe"

Sigcheck v2.90 - File version and signature viewer
Copyright (C) 2004-2022 Mark Russinovich
Sysinternals - www.sysinternals.com

c:\program files (x86)\tmssoftware\data modeler\dm.exe:
** Verified: Signed**
** Signing date: 8:13 AM 26/05/2022**
** Publisher: tmssoftware.com bvba**
** Company: TMS Software**
** Description: TMS Data Modeler**
** Product: TMS Data Modeler**
** Prod version: 3.13.0.0**
** File version: 3.13.0.0**
** MachineType: 32-bit**
** Binary Version: 3.13.0.0**
** Original Name: dm.exe**
** Internal Name: dm**
** Copyright: ⌐ 2010-2017 TMS Software. All rights reserved.**
** Comments: n/a**
** Entropy: 7.922**

//---------------------------------------------
D:\Dev\SigCheck>sigcheck D:\Firebird32\fbclient.dll

Sigcheck v2.90 - File version and signature viewer
Copyright (C) 2004-2022 Mark Russinovich
Sysinternals - www.sysinternals.com

d:\firebird32\fbclient.dll:
Verified: Unsigned
Link date: 11:06 PM 14/07/2025
Publisher: n/a
Company: Firebird Project
Description: Firebird Client library (32-bit)
Product: Firebird SQL Server
Prod version: 4.0.6.3221
File version: WI-V4.0.6.3221
MachineType: 32-bit

//---------------------------------------------
D:\Dev\SigCheck>sigcheck D:\Firebird\fbclient.dll

Sigcheck v2.90 - File version and signature viewer
Copyright (C) 2004-2022 Mark Russinovich
Sysinternals - www.sysinternals.com

d:\firebird\fbclient.dll:
Verified: Unsigned
Link date: 8:03 PM 7/08/2024
Publisher: n/a
Company: Firebird Project
Description: Firebird Client library (64-bit)
Product: Firebird SQL Server
Prod version: 4.0.5.3140
File version: WI-V4.0.5.3140
MachineType: 64-bit

Back to the original problem.
I'm trying to use DataModeler to reverse engineer an existing FB 4 64 bit database.

When doing this the Firebird options are

So FB 4 or FB 5 are not options....

So I choose FB3

I know what I am going to show now will fail because of the bitness..
from the sigheck above D: \Dev|Firebird is 64 bit

It I click on Test Connection I get

All expected.

So I repeat the reverse engineering sequence using the 32 bit fbclient dll

As you can see I am using the 32 bit dll. see the sigcheck data above
This is what I get

So to my way of thinking this is not a bitness issue. A 32 bit application using a 32 bit fbclient dll should be able to access a FB 4 64 bit database.

To me it seems like the ODS On Disk Structure is the problem? I don't have any knowledge of the on disk structures.

Some info here

All Firebird and InterBase On-Disk-Structure (ODS) versions

What do you think?

[White_Simon]

Apologies.
The problem is at my end.
If you have the FB .2.5.x server running and not the later version/s this is what happens.

A 32-bit client application using a 32 bit dll can talk to a 64-bit server process if the 64 bit server is running.

My 64 bit server wasn't..

It seems that both 32 and 64 bit servers can coexist? will check later.

Again.. apologies..
Cheers Simon

[wlandgraf (Wagner Landgraf)]

Thanks for the follow up @White_Simon.