Subject | "Unable to determine field precison from system tables" |
---|---|
Author | Hamish Moffatt |
Post date | 2017-06-08T04:43:46Z |
I've just upgraded my Debian Linux system to the new release (stretch/9)
and now I'm getting the following error when accessing a db from Python,
using either fdb (1.6.1) or the old kinterbasdb (3.3.0).
Unable to determine field precison from system tables:
Dynamic SQL Error
SQL error code = -303
Implementation of text subtype 114 not located.
The query is simply "select version_num from g_version" and the column
in question is an int. I can run this query in isql just fine.
My Firebird server is 2.5, but with the system upgrade I got the new
client library version 3.0.1 (Debian's full version number for it is
3.0.1.32609.ds4-14).
If I downgrade the libfbclient2 package back to 2.5.6, the query succeeds.
The subtype number is sometimes 114 and sometimes 132.
Do I need to stick with the old fbclient library, or is there some I
can/need to do to make this work? I have no plans to upgrade my server
to Firebird 3 yet.
Thanks
Hamish
and now I'm getting the following error when accessing a db from Python,
using either fdb (1.6.1) or the old kinterbasdb (3.3.0).
Unable to determine field precison from system tables:
Dynamic SQL Error
SQL error code = -303
Implementation of text subtype 114 not located.
The query is simply "select version_num from g_version" and the column
in question is an int. I can run this query in isql just fine.
My Firebird server is 2.5, but with the system upgrade I got the new
client library version 3.0.1 (Debian's full version number for it is
3.0.1.32609.ds4-14).
If I downgrade the libfbclient2 package back to 2.5.6, the query succeeds.
The subtype number is sometimes 114 and sometimes 132.
Do I need to stick with the old fbclient library, or is there some I
can/need to do to make this work? I have no plans to upgrade my server
to Firebird 3 yet.
Thanks
Hamish