Firebird 4.0 Connection Error

[Giovane_BXB_Consult]

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

[Jill_Masinde · Accepted solution]

@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:

1. 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.

2. 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.

[Jill_Masinde]

@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!

[Giovane_BXB_Consult]

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

Thank you.

Giovane

[Jill_Masinde]

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

Best Regards

Jill