Help with Kinterbasdb SQL Error -206 Column unknown

[R Baumann]

I'm a newbie with Python, and trying to connect to the Interbase/Firebird
'EMPLOYEE.GDB' file to play with it.

Can anyone help with this?
I'm running Firebird 1.5rc4
Python 2.3.2
kinterbasdb 3.1_pre6-win32-FB1.5-py2.3.exe
winXP Pro SP1

I run the same code at home and it works fine. The only difference is, at
home I'm running Interbase 5.5.

Code follows. . .

Python 2.3.2 (#49, Oct 2 2003, 20:02:00) [MSC v.1200 32 bit (Intel)] on
win32
Type "copyright" , "credits" or "license()" for more information.

*************** *************** *************** *************** ****
Personal firewall software may warn about the connection IDLE
makes to its subprocess using this computer's internal loopback
interface. This connection is not visible on any external
interface and no data is sent to or received from the Internet.
*************** *************** *************** *************** ****

IDLE 1.0[color=blue][color=green][color=darkred]
>>> import kinterbasdb
>>> con = kinterbasdb.con nect([/color][/color][/color]
host='localhost ',
database='c:/Data/FireBirdIB/employee.gdb',
user='SYSDBA',
password='maste rkey',
dialect=3
)[color=blue][color=green][color=darkred]
>>> cur = con.cursor()
>>> cur.execute("SE LECT * FROM EMPLOYEE;")[/color][/color][/color]

Traceback (most recent call last):
File "<pyshell#1 0>", line 1, in -toplevel-
cur.execute("SE LECT * FROM EMPLOYEE;")
File "C:\Python23\Li b\site-packages\kinter basdb\__init__. py", line 1444, in
execute
self.descriptio n = _k.execute(self ._C_cursor, sql, params)
OperationalErro r: (-206, 'Unable to determine field precison from system
tables: Dynamic SQL Error. SQL error code = -206. Column unknown.
FIELD_SPEC.RDB$ FIELD_PRECISION . At line 1, column 19.. ')[color=blue][color=green][color=darkred]
>>>[/color][/color][/color]

Thanks for any help
Ruben

[Jarek Zgoda]

Re: Help with Kinterbasdb SQL Error -206 Column unknown

R Baumann <rynt@9yahoo.co m> pisze:
[color=blue][color=green][color=darkred]
>>>> import kinterbasdb
>>>> con = kinterbasdb.con nect([/color][/color]
> host='localhost ',
> database='c:/Data/FireBirdIB/employee.gdb',
> user='SYSDBA',
> password='maste rkey',
> dialect=3
> )[/color]

Try with dialect 1. If this will not help, check database integrity
(i.e. with IBConsole).

--
Jarek Zgoda
Unregistered Linux User #-1
http://www.zgoda.biz/ JID:zgoda@chrom e.pl http://zgoda.jogger.pl/

[David Rushby]

Re: Help with Kinterbasdb SQL Error -206 Column unknown

"R Baumann" <rynt@9yahoo.co m> wrote in message news:<vr9vphsfu 0j6e5@corp.supe rnews.com>...[color=blue]
> I'm a newbie with Python, and trying to connect to the Interbase/Firebird
> 'EMPLOYEE.GDB' file to play with it.[/color]
[but][color=blue]
> OperationalErro r: (-206, 'Unable to determine field precison from system
> tables: Dynamic SQL Error. SQL error code = -206. Column unknown.
> FIELD_SPEC.RDB$ FIELD_PRECISION . At line 1, column 19.. ')[/color]

Here:

http://sourceforge.net/forum/message.php?msg_id=2287846

[R Baumann]

Re: Help with Kinterbasdb SQL Error -206 Column unknown


"David Rushby" <woodsplitter@r ocketmail.com> wrote in message
news:7876a8ea.0 311142227.175e6 315@posting.goo gle.com...[color=blue]
> "R Baumann" <rynt@9yahoo.co m> wrote in message[/color]
news:<vr9vphsfu 0j6e5@corp.supe rnews.com>...[color=blue][color=green]
> > I'm a newbie with Python, and trying to connect to the[/color][/color]
Interbase/Firebird[color=blue][color=green]
> > 'EMPLOYEE.GDB' file to play with it.[/color]
> [but][color=green]
> > OperationalErro r: (-206, 'Unable to determine field precison from system
> > tables: Dynamic SQL Error. SQL error code = -206. Column unknown.
> > FIELD_SPEC.RDB$ FIELD_PRECISION . At line 1, column 19.. ')[/color]
>
> Here:
> http://sourceforge.net/forum/message.php?msg_id=2287846[/color]

Thanks David! Will look into updating to latest & greatest Firebird and
working with the same versions/data etc., on both home and work computers.
Might make all the difference in the world. :-)

Ruben