Subject | ODBC queries with parameters failing |
---|---|
Author | Kurt Fitzner |
Post date | 2013-02-27T18:18:55Z |
Hello,
I am trying to use Firebird as a back end for LibreOffice Base. I have
downloaded the embedded client and attached it to the ODBC driver, and
it seems to work except in the case of complex queries that use ODBC
parameter markers (question marks) for parameter replacement in SELECT
statements.
First of all, I'd like to make sure this is the problem. The error I'm
getting is: [ODBC Firebird Driver]Sqlda variable has zero length
A thread from a support forum for a product that uses FB as a back end
suggested this error was due to FB not supporting queries that use
question marks as parameter markers. Is this the case?
Secondly, if that is the case, is there any hope that an upcoming
release of the ODBC driver will support this? I am quite eager to use
FB as a back end for my projects.
Thanks in advance for any help,
Kurt Fitzner
I am trying to use Firebird as a back end for LibreOffice Base. I have
downloaded the embedded client and attached it to the ODBC driver, and
it seems to work except in the case of complex queries that use ODBC
parameter markers (question marks) for parameter replacement in SELECT
statements.
First of all, I'd like to make sure this is the problem. The error I'm
getting is: [ODBC Firebird Driver]Sqlda variable has zero length
A thread from a support forum for a product that uses FB as a back end
suggested this error was due to FB not supporting queries that use
question marks as parameter markers. Is this the case?
Secondly, if that is the case, is there any hope that an upcoming
release of the ODBC driver will support this? I am quite eager to use
FB as a back end for my projects.
Thanks in advance for any help,
Kurt Fitzner