topic Re: Firebird 4.0 Connection Error in QlikView

Firebird 4.0 Connection Error

Giovane_BXB_Consult — Mon, 26 Jan 2026 21:26:37 GMT

Hi, everyone...

Recently the ERP's DB of one of our clients has been updated to 4.0 version. After making the appropriate change to the ODBC connection, the following error started happening:

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: HY000, ErrorCode: 4294966795, ErrorMsg: [ODBC Firebird Driver][Firebird]Attempt to reclose a closed cursor

Can anyone give a way to overcome this issue?

Thank you all for your attention.

Cheers.

Giovane

Re: Firebird 4.0 Connection Error

Jill_Masinde — Mon, 09 Sep 2024 14:30:12 GMT

@Giovane_BXB_Consult

It looks like you're encountering an issue with an ODBC connection to a Firebird database. The error message [ODBC Firebird Driver][Firebird]Attempt to reclose a closed cursor indicates that there was an attempt to close a cursor that was already closed.

Here are a few things you might consider to troubleshoot and resolve this issue:

Check Cursor Management: Ensure that your application code is correctly managing cursors. Make sure you’re not attempting to close a cursor more than once. Review the parts of your code where cursors are opened and closed to ensure they are being handled properly.
Database Driver Version: Make sure you’re using the latest version of the Firebird ODBC driver. Sometimes, driver updates can fix bugs and improve compatibility.

Re: Firebird 4.0 Connection Error

Jill_Masinde — Wed, 11 Sep 2024 15:39:38 GMT

@Giovane_BXB_Consult Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

Re: Firebird 4.0 Connection Error

Giovane_BXB_Consult — Tue, 26 Nov 2024 14:16:31 GMT

You're right, Jill_Masinde. It's a firebird odbc driver issue. Once updated the problem is solved.

Thank you.

Giovane

Re: Firebird 4.0 Connection Error

Jill_Masinde — Tue, 26 Nov 2024 14:29:48 GMT

@Giovane_BXB_Consult Thank you for your feedback and confirming this issue is resolved.

Best Regards

Jill