Re: [firebird-support] "Unable to determine field precison from system tables"

2017-06-07 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
On 08/06/17 14:43, Hamish Moffatt ham...@risingsoftware.com 
[firebird-support] wrote:



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



False alarm, my script was still using kinterbasdb. When I switch to fdb 
it works fine.


Sorry for the noise,

Hamish


[firebird-support] "Unable to determine field precison from system tables"

2017-06-07 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]

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