search

FirebirdSQL / firebird-odbc-driver

Firebird ODBC driver
https://firebirdsql.org/en/odbc-driver/
42 stars 11 forks source link

Support for WireCompression with ODBC #203

Closed bogdan-soare closed 2 years ago

bogdan-soare commented 2 years ago

Is there any way to implement WireCompression using the Firebird ODBC driver? At the server I have set WireCompression=true in firebird.conf and I have restarted the service. At the client I have set WireCompression=true in firebird.conf which is located in the same folder as fbclient.dll and zlib1.dll.

When connecting to the remote database through the ODBC driver, from Visual Fox Pro, I noticed that WireCompression is not used. The connection string refers to the location of the fbclient.dll mentioned earlier. The ODBC driver's version is 2.0.5.156.

mrotteveel commented 2 years ago

That would suggest that the ODBC driver is using a different fbclient.dll than the one that has the firebird.conf and zlib1.dll, or that the fbclient.dll and/or zlib1.dll is 64-bit instead of 32-bit (iirc FoxPro is 32-bit only).

bogdan-soare commented 2 years ago

You are right! I was using the wrong zlib1.dll from the 64 bit install of the Firebird Server rather than the one from the 32 bit install. Now it works. Thanks a lot!