ODBC Driver crashes wenn I connect it to the Database

[Simon Bajt]

Hello!

I have trouble to install an odbc Connection with the Firebird DB.

A few information about the environment:

We use a Software that uses an Firebird Database. the Version of the Database is 2.5.3.26778 and my driver version is 2.0.5.156 (latest available at https://www.firebirdsql.org/en/odbc-driver/)

My configuration in ODBC looks like this:

Database: E:\Haufe\PwrHaus\DAT\pwrhse.gdb -> PwrHaus is the name of the Software that uses the Firebird DB

Client C:\Users\administrator\Downloads\OdbcFb_DLL_2.0.5.156_x64\OdbcFb.dll

If try to test the connection, ODBC crashes but I can safe it. If I try to connect to the database over Excel, it says that the connection isn't possible & there aren't any error information.

For our tests, we deactivated any Anti Virus Endpoint & Firewall and we tried it on the DB host & Remote with 4 different Clients.

[Mark Rotteveel]

On 11-11-2021 14:50, Simon Bajt wrote:
> I have trouble to install an odbc Connection with the Firebird DB.
>
> A few information about the environment:
>
> We use a Software that uses an Firebird Database. the Version of the
> Database is 2.5.3.26778 and my driver version is 2.0.5.156 (latest
> available at https://www.firebirdsql.org/en/odbc-driver/)

> <https://www.firebirdsql.org/en/odbc-driver/)>

The latest Firebird 2.5 is 2.5.9, you're missing a few years of bug
fixes (including security fix 2.5.3 Update 1). I highly recommend
updating your Firebird database to at least 2.5.9.

> My configuration in ODBC looks like this:
>
> Database: E:\Haufe\PwrHaus\DAT\pwrhse.gdb -> PwrHaus is the name of the
> Software that uses the Firebird DB
>
> Client C:\Users\administrator\Downloads\OdbcFb_DLL_2.0.5.156_x64\OdbcFb.dll

This is probably the problem, you're pointing to a Firebird ODBC library
file, but this should point to a Firebird client library (fbclient.dll).

Mark
--
Mark Rotteveel

[Simon Bajt]

Hello Mark,

thank you for your response.
I will try to Update the Firebird Database.

I reconfigured the ODBC Driver and pointed it to the fbclient.dll from the Setup and it worked on the DB-Server.

Now I have the next Problem:
I try to configure the odbc Driver on a Client with the folowing Parameters:
Database:
hostname.domainname:3050/E:\haufe\Pwrhaus\dat\pwrhse.gdb

Client:
C:\Users\administrator\Desktop\fbclient.dll

Now I get the error:
   'Connection failed, unavailable Database'

I deactivated every Firewall & Endpoint in between but same error.  

Simon Bajt

[Mark Rotteveel]

On 15-11-2021 14:13, Simon Bajt wrote:
> I reconfigured the ODBC Driver and pointed it to the fbclient.dll from
> the Setup and it worked on the DB-Server.
>
> Now I have the next Problem:
> I try to configure the odbc Driver on a Client with the folowing Parameters:
> Database:
> hostname.domainname:3050/E:\haufe\Pwrhaus\dat\pwrhse.gdb
>
> Client:
> C:\Users\administrator\Desktop\fbclient.dll
>
> Now I get the error:
>    'Connection failed, unavailable Database'
>
> I deactivated every Firewall & Endpoint in between but same error.

You're using the wrong URL. It should be:

hostname.domainname/3050:E:\haufe\Pwrhaus\dat\pwrhse.gdb

In this format of Firebird URLs, the port is separate from the host name
by a `/`, and the path or alias by a `:`.

You can also leave the port out, as 3050 is the default port, then the
URL is:

hostname.domainname:E:\haufe\Pwrhaus\dat\pwrhse.gdb

Mark
--
Mark Rotteveel