Blobs in Interbase
9 answers - 6023 bytes -

Hi Bob,
Thanks again for your reply.
I've tried this approach before, so I'm thinking perhaps its my db adaptor.
Which one are you using, if you don't mind me asking?
I've had trouble installing kinterbase (it complains about LDAP?), so at
the moment I use gvib. I've pencilled in quite a bit of time today to try to
get kinterbase installed.
Unfortunately I'm on Windows, which I'm guessing contributes to the
installation problems!
Thanks once again for your help and your time. If this doesn't work, I'll
look for the Zope-DB list, and basically go and bother someone else.
Cheers
Ashley
>From: Bob Corriher <bobc (AT) p-wave (DOT) com>
>To: CC: ashleylloyd (AT) hotmail (DOT) com
>Subject: Blobs in Interbase
>Date: Mon, 01 Aug 2005 12:23:55 -0400
>
>Hi Ashely,
>
>I use Interbase (and Firebird) in Zope regularly and I just use the regular
>ZSQL Method syntax for blob fields:
>
><dtml-sqlvar name="blob_fld" type="nb">
>
>to update the field.If the field may be left null, I usually use something
>like this in the ZSQL Method:
>
><dtml-if blob_fld>
><dtml-sqlvar name="blob_fld" type="nb">
><dtml-else>
>null
></dtml-if>
>
>Apply commas at the end (or beginning) of the <dtml-sqlvarand null if
>necessary.
>
>This should work for Interbase from version 4.x thru Interbase 6.x and for
>all versions of Firebird.
>
>If you need further help, just email me (and the list). Also, there is a
>Zope-DB list for discussing Zope and RDBMS issues and the real gurus hang
>out there.
>
>HTH
>
>Bob Corriher
>CT
>P-Wave Inc.
>
>Ashley wrote:
>
>Hi bobb, thanks for your reply.
>
>If I found the right post (reading an image from blob in mysql and
>displaying it), then thanks very much but I don't think it'll apply too
>much
>to my situation. I can retrieve the contents of the blob field fine, its
>updating it that causes the problems.
>
>Thanks again, though.
>
>I posted directly out of Express, by the way, just hitting "New
>Post".
>
>Kind regards
>
>Ashley
>
>
>
>"bobb" <rawsystems (AT) gmail (DOT) comwrote in message
>news:009101c59513$c40d4b50$6400a8c0@rawlt1
>
I posted some stuff I was doing some time ago w/ mysql / blobs and zope
>>
>>
>some
>
time ago so that my grandchildren could google for it :)
if you goggle for zope mysql blob bobb
you'll get it. It's not interbase.
hth
bobb
Also, your post came through as a newsgroup posting, which means I had to
cut / paste / finagle the whole thing to reply It's the first time
I've
ever seen that (I use m$ outlook express) How are you posting to here?
(curious, that's all)
"Ashley" <ashleylloyd (AT) hotmail (DOT) comwrote in message
news:dcd0n1$ida$1 (AT) sea (DOT) gmane.org
>>
>>
I'm not sure if this is the right place for this, if not, my
apologies.
>
I've got a Clients table in an interbase db with various fields, one
of
which is a BLB field (subtype text), used to maintain some notes.
>
When inserting a Client into the table, this field populates fine.
>
However, when attempting to update the client, for some reason, it
>won't.
>
It
>>
>>
just will not allow me to do an update with the notes field in the
statement. I've googled around, and found lots of bits helping with
Delphi,
>>
>>
and lots of statements that BLB fields in Interbase are tricky to
>update,
>
but nothing that helps.
>
Has anyone out there found a way around this?
>
I'm using currently using gvib as my database adaptor, as kinterbase
>does
>
not seem to want to install at all (seemingly problems with ldap ).
>
My Zope instance is installed from a Plone installer.
Zope Version (Zope 2.6.1 (binary release, python 2.1,
win32-x86),
python 2.1.3, win32)
Python Version 2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit
(Intel)]
>>
>>
System Platform win32
>
>
Thanks in advance
Ashley
>
>
>
Zope maillist - Zope (AT) zope (DOT) org
** No cross posts or HTML encoding! **
(Related lists -
)
Zope maillist - Zope (AT) zope (DOT) org
No cross posts or HTML encoding! **
(Related lists -
)
>>
>>
>
>
>
>
>
>
>
>
>
>
>No virus found in this outgoing message.
>Checked by AVG Anti-Virus.
>Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005
>
Zope maillist - Zope (AT) zope (DOT) org
** No cross posts or HTML encoding! **
(Related lists -
)
No.1 | | 762 bytes |
| 
Hi Ashley,
Can't help you on the blob front
Ashley Lloyd wrote:
I've had trouble installing kinterbase (it complains about LDAP?), so
at the moment I use gvib. I've pencilled in quite a bit of time today to
try to get kinterbase installed.
Unfortunately I'm on Windows, which I'm guessing contributes to the
installation problems!
but I can confirm that KIinterbaseDA works nicely on Windows - I've
been happily using it for some time, and haven't had any issues at all
(BTW, I don't use LDAP and KInterbaseDA has never mentioned it!). The
only problem I had at install time was getting my head around the
distinction between the Python part and the Zope DA part.
HTH
No.2 | | 2655 bytes |
| 
Hi Phil,
Thanks for your email.
The LDAP error, as it turns out, was from "zkinterbasdb" or something like
that - something I probably picked up thinking it was kinterbase.
Forgive my ignorance, but what was your procedure for installing kinterbase?
I've tried just installing kinterbasDA, which required kinterbasdb. So I've
tried installing kinterbasdb (from an executable, rather than the more
familiar simple compressed file), but I keep getting an ImportError: DLL
load failed when looking at the product in Control_Panel/Products.
The error refers to a line "import _kinterbasdb as _k". I've assumed that
its referring to import _kinterbasdb.pyd, rather than a dll, as thats all
that I can find. I've tried copying it into several places, but I'm assuming
that its compiled by the exe at install time, and is specific to the folder
its placed in. I could be completely wrong!
Any hints as to your procedure would be appreciated, as this is getting
frustrating (probably meaning I'm missing stupid things).
Thanks
Ashley
Message
From: "Philip Kilner" <phil (AT) xfr (DOT) co.uk>
To: "Ashley Lloyd" <ashleylloyd (AT) hotmail (DOT) com>
Cc: <bobc (AT) p-wave (DOT) com>; <zope (AT) zope (DOT) org>
Sent: Tuesday, August 02, 2005 11:14 AM
Subject: Re: [Zope] RE: Blobs in Interbase
Hi Ashley,
Can't help you on the blob front
Ashley Lloyd wrote:
I've had trouble installing kinterbase (it complains about LDAP?), so
at the moment I use gvib. I've pencilled in quite a bit of time today to
try to get kinterbase installed.
Unfortunately I'm on Windows, which I'm guessing contributes to the
installation problems!
--
but I can confirm that KIinterbaseDA works nicely on Windows - I've
been happily using it for some time, and haven't had any issues at all
(BTW, I don't use LDAP and KInterbaseDA has never mentioned it!). The
only problem I had at install time was getting my head around the
distinction between the Python part and the Zope DA part.
HTH
--
--
Regards,
PhilK
Email: phil (AT) xfr (DOT) co.uk
PGP Public key: http://www.xfr.co.uk
Voicemail & Facsimile: 07092 070518
"You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start."
- Tony Harrison
Zope maillist - Zope (AT) zope (DOT) org
** No cross posts or HTML encoding! **
(Related lists -
)
No.3 | | 2407 bytes |
| 
Hi Ashley,
Ashley Lloyd wrote:
The LDAP error, as it turns out, was from "zkinterbasdb" or something like
that - something I probably picked up thinking it was kinterbase.
Aha - thought it was unlikely to be from the DA!
Forgive my ignorance, but what was your procedure for installing kinterbase?
I've tried just installing kinterbasDA, which required kinterbasdb. So I've
tried installing kinterbasdb (from an executable, rather than the more
familiar simple compressed file), but I keep getting an ImportError: DLL
load failed when looking at the product in Control_Panel/Products.
The error refers to a line "import _kinterbasdb as _k". I've assumed that
its referring to import _kinterbasdb.pyd, rather than a dll, as thats all
that I can find. I've tried copying it into several places, but I'm assuming
that its compiled by the exe at install time, and is specific to the folder
its placed in. I could be completely wrong!
You want a .pyd, not a .dll - that bit's fine.
I may have started from a different point from you - I have a Plone
install with multiple Zope and Plone sites in it, and Plone does a
couple of things differently. In a Plone install on Windows, the Plone's
Python is set as the system's Python. This means that when you run the
binary installer for kinterbasdb it installs in the right copy of
Python. I wonder if you have Python installed elsewhere, and the binary
installer is finding the wrong one?
The other thing is the mxExtensions - do you have these installed?
Any hints as to your procedure would be appreciated, as this is getting
frustrating (probably meaning I'm missing stupid things).
I didn't do anything beyond what the docs for the three packages (mx
Extensions, Python db i/f, Zope DA) stated - but there is always the joy
of working out what those instructions /really/ mean, as in "now I've
done it, I understand it! I do remember some frustration, but I think it
was just the system Python thing.
If the above doesn't help, the traceback from your error should be our
starting point - stick with it, because since installing it I haven't
even needed to think about this DA except when I've upgraded it, it just
works (for me - YMMV and all that)!
No.4 | | 1646 bytes |
| 
Hi Phil & Ashley,
I also have kinterbasedbDA working on Windows. It is with an older
version of Zope (2.6.4). The DA version is 1.1.1.1. The kinterbasdb
version is 3.0.1. It uses a dll called _kinterbasedb.dll, instead of a
pyd. I don't remember the exact installation process anymore, but I
think I just grabbed it from another working site. If you like, I could
zip it up and send it to you.
The site uses blobs (all sub_type text) in many places, so maybe
older/other versions don't support this as well.
Bob Corriher
CT
P-Wave Inc.
Philip Kilner wrote:
>Hi Ashley,
>
>Can't help you on the blob front
>
>Ashley Lloyd wrote:
>
>>I've had trouble installing kinterbase (it complains about LDAP?), so
>>at the moment I use gvib. I've pencilled in quite a bit of time today to
>>try to get kinterbase installed.
>>Unfortunately I'm on Windows, which I'm guessing contributes to the
>>installation problems!
>>
>
>>
>
>but I can confirm that KIinterbaseDA works nicely on Windows - I've
>been happily using it for some time, and haven't had any issues at all
>(BTW, I don't use LDAP and KInterbaseDA has never mentioned it!). The
>only problem I had at install time was getting my head around the
>distinction between the Python part and the Zope DA part.
>
>HTH
>
>
No.5 | | 2511 bytes |
| 
Hi Bob,
If you don't mind doing that, I'd really appreciate it.
Nothing I seem to be trying to install at the moment seems to be working.
As with Phil, mine is from a Plone install, but I have got other versions of
Python elsewhere, (I think there's even an old Zope standalone instance
still lurking somewhere, altho I don't think it can run) just to confuse
matters.
Anyway, my Zope is even older - 2.6.1, so hopefully it'll be compatible.
Thanks very much again for your help.
Ashley
Message
From: "Bob Corriher" <bobc (AT) p-wave (DOT) com>
To: <phil (AT) xfr (DOT) co.uk>
Cc: "Ashley Lloyd" <ashleylloyd (AT) hotmail (DOT) com>; <zope (AT) zope (DOT) org>
Sent: Tuesday, August 02, 2005 4:01 PM
Subject: Re: [Zope] RE: Blobs in Interbase
Hi Phil & Ashley,
I also have kinterbasedbDA working on Windows. It is with an older
version of Zope (2.6.4). The DA version is 1.1.1.1. The kinterbasdb
version is 3.0.1. It uses a dll called _kinterbasedb.dll, instead of a
.pyd. I don't remember the exact installation process anymore, but I
think I just grabbed it from another working site. If you like, I could
zip it up and send it to you.
The site uses blobs (all sub_type text) in many places, so maybe
older/other versions don't support this as well.
Bob Corriher
CT
P-Wave Inc.
Philip Kilner wrote:
>
>Hi Ashley,
>
>Can't help you on the blob front
>
>Ashley Lloyd wrote:
>
>
>>I've had trouble installing kinterbase (it complains about LDAP?), so
>>at the moment I use gvib. I've pencilled in quite a bit of time today to
>>try to get kinterbase installed.
>>Unfortunately I'm on Windows, which I'm guessing contributes to the
>>installation problems!
>>
>>
>>
>
>but I can confirm that KIinterbaseDA works nicely on Windows - I've
>been happily using it for some time, and haven't had any issues at all
>(BTW, I don't use LDAP and KInterbaseDA has never mentioned it!). The
>only problem I had at install time was getting my head around the
>distinction between the Python part and the Zope DA part.
>
>HTH
>
>
>
>
>
>
>
No.6 | | 3430 bytes |
| 
Bob, you're a star!
I unpacked it, restarted Zope, and there it was!
Marvellous, I've now got a kinterbase installed that works.
Thats the good news.
The bad news is I still can't update the blob field - I still get errors. I think, unless anyone here has any more ideas, I'll have to go and bother people in another mailing list.
I've tried absolutely everything I can think of - sqlvar tags of type string and nb, trying cast( as blob) in the sql (doesn't seem to work), I've even just tried setting it to 'Hello world', without using any dtml variables at all, and it won't accept it.
>From what I've read elsewhere, there are tools in some software (mostly for Delphi I believe), that will allow updates of text blob fields, so I was hoping that kinterbasdb had something in it as well, but if it does, it isn't working on mine!!
The interbase version is 6.0-6.1, if that jogs any memories for anyone.
Thanks once again to everyone who has tried to help me.
Kind regards
Ashley
Ashley Lloyd wrote:
Hi Bob,
If you don't mind doing that, I'd really appreciate it.
Nothing I seem to be trying to install at the moment seems to be working.
As with Phil, mine is from a Plone install, but I have got other versions of
Python elsewhere, (I think there's even an old Zope standalone instance
still lurking somewhere, altho I don't think it can run) just to confuse
matters.
Anyway, my Zope is even older - 2.6.1, so hopefully it'll be compatible.
Thanks very much again for your help.
Ashley
Message
From: "Bob Corriher" <bobc (AT) p-wave (DOT) com>
To: <phil (AT) xfr (DOT) co.uk>
Cc: "Ashley Lloyd" <ashleylloyd (AT) hotmail (DOT) com>; <zope (AT) zope (DOT) org>
Sent: Tuesday, August 02, 2005 4:01 PM
Subject: Re: [Zope] RE: Blobs in Interbase
Hi Phil & Ashley,
I also have kinterbasedbDA working on Windows. It is with an older
version of Zope (2.6.4). The DA version is 1.1.1.1. The kinterbasdb
version is 3.0.1. It uses a dll called _kinterbasedb.dll, instead of a
pyd. I don't remember the exact installation process anymore, but I
think I just grabbed it from another working site. If you like, I could
zip it up and send it to you.
The site uses blobs (all sub_type text) in many places, so maybe
older/other versions don't support this as well.
Bob Corriher
CT
P-Wave Inc.
Philip Kilner wrote:
Hi Ashley,
Can't help you on the blob front
Ashley Lloyd wrote:
I've had trouble installing kinterbase (it complains about LDAP?), so
at the moment I use gvib. I've pencilled in quite a bit of time today to
try to get kinterbase installed.
Unfortunately I'm on Windows, which I'm guessing contributes to the
installation problems!
but I can confirm that KIinterbaseDA works nicely on Windows - I've
been happily using it for some time, and haven't had any issues at all
(BTW, I don't use LDAP and KInterbaseDA has never mentioned it!). The
only problem I had at install time was getting my head around the
distinction between the Python part and the Zope DA part.
HTH
No.7 | | 4467 bytes |
| 
Hi Ashley,
down, one to go. I've used this adapter with Interbase 6.0 with no
problems, although I've since upgraded to Firebird.
Perhaps you could send the error traceback you get, we could get some
clues from that. Also, the metadata from the table that shows the
problem. It's got to be in there somewhere.
Bob Corriher
CT
P-Wave Inc.
Ashley Lloyd wrote:
Bob, you're a star!
I unpacked it, restarted Zope, and there it was!
Marvellous, I've now got a kinterbase installed that works.
Thats the good news.
The bad news is I still can't update the blob field - I still get
errors. I think, unless anyone here has any more ideas, I'll have to
go and bother people in another mailing list.
I've tried absolutely everything I can think of - sqlvar tags of type
string and nb, trying cast( as blob) in the sql (doesn't seem to
work), I've even just tried setting it to 'Hello world', without using
any dtml variables at all, and it won't accept it.
From what I've read elsewhere, there are tools in some software
(mostly for Delphi I believe), that will allow updates of text blob
fields, so I was hoping that kinterbasdb had something in it as well,
but if it does, it isn't working on mine!!
The interbase version is 6.0-6.1, if that jogs any memories for anyone.
Thanks once again to everyone who has tried to help me.
Kind regards
Ashley
--
Ashley Lloyd wrote:
>
>>Hi Bob,
>>
>>If you don't mind doing that, I'd really appreciate it.
>>Nothing I seem to be trying to install at the moment seems to be working.
>>
>>As with Phil, mine is from a Plone install, but I have got other versions of
>>Python elsewhere, (I think there's even an old Zope standalone instance
>>still lurking somewhere, altho I don't think it can run) just to confuse
>>matters.
>>Anyway, my Zope is even older - 2.6.1, so hopefully it'll be compatible.
>>
>>Thanks very much again for your help.
>>
>>Ashley
>>
>Message
>>From: "Bob Corriher" <bobc (AT) p-wave (DOT) com>
>>To: <phil (AT) xfr (DOT) co.uk>
>>Cc: "Ashley Lloyd" <ashleylloyd (AT) hotmail (DOT) com>; <zope (AT) zope (DOT) org>
>>Sent: Tuesday, August 02, 2005 4:01 PM
>>Subject: Re: [Zope] RE: Blobs in Interbase
>>
>>
>
>>
Hi Phil & Ashley,
I also have kinterbasedbDA working on Windows. It is with an older
version of Zope (2.6.4). The DA version is 1.1.1.1. The kinterbasdb
version is 3.0.1. It uses a dll called _kinterbasedb.dll, instead of a
pyd. I don't remember the exact installation process anymore, but I
think I just grabbed it from another working site. If you like, I could
zip it up and send it to you.
The site uses blobs (all sub_type text) in many places, so maybe
older/other versions don't support this as well.
Bob Corriher
CT
P-Wave Inc.
Philip Kilner wrote:
Hi Ashley,
Can't help you on the blob front
Ashley Lloyd wrote:
I've had trouble installing kinterbase (it complains about LDAP?), so
at the moment I use gvib. I've pencilled in quite a bit of time today to
try to get kinterbase installed.
Unfortunately I'm on Windows, which I'm guessing contributes to the
installation problems!
but I can confirm that KIinterbaseDA works nicely on Windows - I've
been happily using it for some time, and haven't had any issues at all
(BTW, I don't use LDAP and KInterbaseDA has never mentioned it!). The
only problem I had at install time was getting my head around the
distinction between the Python part and the Zope DA part.
HTH
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date: 8/1/2005
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date: 8/1/2005
No.8 | | 6761 bytes |
| 
Hi Bob, thanks again!!
When attempting to update the entity, I get the following error details:
Error Type ProgrammingError
Error Value (-413, 'execute.isc_dsql_execute: conversion error from string
"BLB". ')
Error Trace Traceback (most recent call last):
File "C:\Program
Files\ESPPlone\Zope\lib\python\DocumentTemplate\DT _Try.py", line 149, in
render_try_except
result = render_blocks(self.section, md)
File "C:\Program
Files\ESPPlone\Zope\lib\python\DocumentTemplate\DT _Util.py", line 201, in
eval
return eval(code, d)
File "", line 2, in f
File "C:\Program Files\ESPPlone\Zope\lib\python\Shared\DC\ZRDB\DA.p y", line
428, in __call__
else: result=DBquery(query, self.max_rows_)
File "C:\Program
Files\ESPPlone\Zope\lib\python\Products\kinterbasd bDA\db.py", line 198, in
query
self.cursor.execute(src)
File "C:\Program
Files\ESPPlone\Zope\lib\python\Products\kinterbasd bDA\kinterbasdb\__init
py", line 585, in execute
res = _kinterbasdb.execute(self._C_cursor, sql, params)
ProgrammingError: (-413, 'execute.isc_dsql_execute: conversion error from
string "BLB". ')
I get the same error type and value when testing the SQL method (I've tried
to isolate the problem in its own method, leaving the updates to other
fields in a seperate SQL method) in the ZMI, and the SQL that is generated
is:
UPDATE ENTITY
SET EN_NTES = 'Hello world'
WHERE EN_KEY = 12
Simple!
The metatata of the table has the notes field definition as:
EN_NTES BLB SUB_TYPE 1 SEGMENT SIZE 80,
There is nothing else of any real interest in the table - an update that
does not involve the notes works perfectly!
Thanks once again to you and everyone who has tried to help!
Cheers
Ashley
Message
From: "Bob Corriher" <bobc (AT) p-wave (DOT) com>
To: "Ashley Lloyd" <ashleylloyd (AT) hotmail (DOT) com>; <zope (AT) zope (DOT) org>
Sent: Wednesday, August 03, 2005 2:31 PM
Subject: Re: [Zope] RE: Blobs in Interbase
Hi Ashley,
down, one to go. I've used this adapter with Interbase 6.0 with no
problems, although I've since upgraded to Firebird.
Perhaps you could send the error traceback you get, we could get some
clues from that. Also, the metadata from the table that shows the
problem. It's got to be in there somewhere.
Bob Corriher
CT
P-Wave Inc.
--
Ashley Lloyd wrote:
Bob, you're a star!
I unpacked it, restarted Zope, and there it was!
Marvellous, I've now got a kinterbase installed that works.
Thats the good news.
The bad news is I still can't update the blob field - I still get
errors. I think, unless anyone here has any more ideas, I'll have to
go and bother people in another mailing list.
I've tried absolutely everything I can think of - sqlvar tags of type
string and nb, trying cast( as blob) in the sql (doesn't seem to
work), I've even just tried setting it to 'Hello world', without using
any dtml variables at all, and it won't accept it.
From what I've read elsewhere, there are tools in some software
(mostly for Delphi I believe), that will allow updates of text blob
fields, so I was hoping that kinterbasdb had something in it as well,
but if it does, it isn't working on mine!!
The interbase version is 6.0-6.1, if that jogs any memories for anyone.
Thanks once again to everyone who has tried to help me.
Kind regards
Ashley
--
Ashley Lloyd wrote:
>
>>Hi Bob,
>>
>>If you don't mind doing that, I'd really appreciate it.
>>Nothing I seem to be trying to install at the moment seems to be
working.
>>
>>As with Phil, mine is from a Plone install, but I have got other
versions of
>>Python elsewhere, (I think there's even an old Zope standalone instance
>>still lurking somewhere, altho I don't think it can run) just to confuse
>>matters.
>>Anyway, my Zope is even older - 2.6.1, so hopefully it'll be compatible.
>>
>>Thanks very much again for your help.
>>
>>Ashley
>>
>Message
>>From: "Bob Corriher" <bobc (AT) p-wave (DOT) com>
>>To: <phil (AT) xfr (DOT) co.uk>
>>Cc: "Ashley Lloyd" <ashleylloyd (AT) hotmail (DOT) com>; <zope (AT) zope (DOT) org>
>>Sent: Tuesday, August 02, 2005 4:01 PM
>>Subject: Re: [Zope] RE: Blobs in Interbase
>>
>>
>>
>>
Hi Phil & Ashley,
I also have kinterbasedbDA working on Windows. It is with an older
version of Zope (2.6.4). The DA version is 1.1.1.1. The kinterbasdb
version is 3.0.1. It uses a dll called _kinterbasedb.dll, instead of a
pyd. I don't remember the exact installation process anymore, but I
think I just grabbed it from another working site. If you like, I could
zip it up and send it to you.
The site uses blobs (all sub_type text) in many places, so maybe
older/other versions don't support this as well.
Bob Corriher
CT
P-Wave Inc.
Philip Kilner wrote:
Hi Ashley,
Can't help you on the blob front
Ashley Lloyd wrote:
I've had trouble installing kinterbase (it complains about LDAP?),
so
at the moment I use gvib. I've pencilled in quite a bit of time today
to
try to get kinterbase installed.
Unfortunately I'm on Windows, which I'm guessing contributes to the
installation problems!
but I can confirm that KIinterbaseDA works nicely on Windows - I've
been happily using it for some time, and haven't had any issues at all
(BTW, I don't use LDAP and KInterbaseDA has never mentioned it!). The
only problem I had at install time was getting my head around the
distinction between the Python part and the Zope DA part.
HTH
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date: 8/1/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date:
8/1/2005
>
>
>
>
No.9 | | 7860 bytes |
| 
Hi Ashley,
This error rings a bell with me. I can't remember where or what I did
for sure, but I think I might have just forced a conversion to a string
(with str()) before I updated the table It might have been with a
unicode string. You could do this before you pass the parameter to the
ZSQL Method. It might be worth a try.
Bob Corriher
CT
P-Wave Inc.
Ashley Lloyd wrote:
>Hi Bob, thanks again!!
>
>When attempting to update the entity, I get the following error details:
>
>Error Type ProgrammingError
>
>Error Value (-413, 'execute.isc_dsql_execute: conversion error from string
>"BLB". ')
>
>Error Trace Traceback (most recent call last):
>File "C:\Program
>Files\ESPPlone\Zope\lib\python\DocumentTemplate\DT _Try.py", line 149, in
>render_try_except
>result = render_blocks(self.section, md)
>File "C:\Program
>Files\ESPPlone\Zope\lib\python\DocumentTemplate\DT _Util.py", line 201, in
>eval
>return eval(code, d)
>File "", line 2, in f
>File "C:\Program Files\ESPPlone\Zope\lib\python\Shared\DC\ZRDB\DA.p y", line
>428, in __call__
>else: result=DBquery(query, self.max_rows_)
>File "C:\Program
>Files\ESPPlone\Zope\lib\python\Products\kinterbasd bDA\db.py", line 198, in
>query
>self.cursor.execute(src)
>File "C:\Program
>Files\ESPPlone\Zope\lib\python\Products\kinterbasd bDA\kinterbasdb\__init
>py", line 585, in execute
>res = _kinterbasdb.execute(self._C_cursor, sql, params)
>ProgrammingError: (-413, 'execute.isc_dsql_execute: conversion error from
>string "BLB". ')
>
>I get the same error type and value when testing the SQL method (I've tried
>to isolate the problem in its own method, leaving the updates to other
>fields in a seperate SQL method) in the ZMI, and the SQL that is generated
>is:
>UPDATE ENTITY
>SET EN_NTES = 'Hello world'
>WHERE EN_KEY = 12
>Simple!
>
>The metatata of the table has the notes field definition as:
>EN_NTES BLB SUB_TYPE 1 SEGMENT SIZE 80,
>
>There is nothing else of any real interest in the table - an update that
>does not involve the notes works perfectly!
>
>Thanks once again to you and everyone who has tried to help!
>
>Cheers
>Ashley
>
Message
>From: "Bob Corriher" <bobc (AT) p-wave (DOT) com>
>To: "Ashley Lloyd" <ashleylloyd (AT) hotmail (DOT) com>; <zope (AT) zope (DOT) org>
>Sent: Wednesday, August 03, 2005 2:31 PM
>Subject: Re: [Zope] RE: Blobs in Interbase
>
>
>
>>Hi Ashley,
>>
>down, one to go. I've used this adapter with Interbase 6.0 with no
>>problems, although I've since upgraded to Firebird.
>>
>>Perhaps you could send the error traceback you get, we could get some
>>clues from that. Also, the metadata from the table that shows the
>>problem. It's got to be in there somewhere.
>>
>>Bob Corriher
>>CT
>>P-Wave Inc.
>>
>>
>>Ashley Lloyd wrote:
>>
>
>>
Bob, you're a star!
I unpacked it, restarted Zope, and there it was!
Marvellous, I've now got a kinterbase installed that works.
Thats the good news.
The bad news is I still can't update the blob field - I still get
errors. I think, unless anyone here has any more ideas, I'll have to
go and bother people in another mailing list.
I've tried absolutely everything I can think of - sqlvar tags of type
string and nb, trying cast( as blob) in the sql (doesn't seem to
work), I've even just tried setting it to 'Hello world', without using
any dtml variables at all, and it won't accept it.
From what I've read elsewhere, there are tools in some software
(mostly for Delphi I believe), that will allow updates of text blob
fields, so I was hoping that kinterbasdb had something in it as well,
but if it does, it isn't working on mine!!
The interbase version is 6.0-6.1, if that jogs any memories for anyone.
Thanks once again to everyone who has tried to help me.
Kind regards
Ashley
Ashley Lloyd wrote:
Hi Bob,
If you don't mind doing that, I'd really appreciate it.
Nothing I seem to be trying to install at the moment seems to be
>working.
As with Phil, mine is from a Plone install, but I have got other
>versions of
Python elsewhere, (I think there's even an old Zope standalone instance
still lurking somewhere, altho I don't think it can run) just to confuse
matters.
Anyway, my Zope is even older - 2.6.1, so hopefully it'll be compatible.
Thanks very much again for your help.
Ashley
Message
From: "Bob Corriher" <bobc (AT) p-wave (DOT) com>
To: <phil (AT) xfr (DOT) co.uk>
Cc: "Ashley Lloyd" <ashleylloyd (AT) hotmail (DOT) com>; <zope (AT) zope (DOT) org>
Sent: Tuesday, August 02, 2005 4:01 PM
Subject: Re: [Zope] RE: Blobs in Interbase
Hi Phil & Ashley,
I also have kinterbasedbDA working on Windows. It is with an older
version of Zope (2.6.4). The DA version is 1.1.1.1. The kinterbasdb
version is 3.0.1. It uses a dll called _kinterbasedb.dll, instead of a
pyd. I don't remember the exact installation process anymore, but I
think I just grabbed it from another working site. If you like, I could
zip it up and send it to you.
The site uses blobs (all sub_type text) in many places, so maybe
older/other versions don't support this as well.
Bob Corriher
CT
P-Wave Inc.
Philip Kilner wrote:
Hi Ashley,
Can't help you on the blob front
Ashley Lloyd wrote:
I've had trouble installing kinterbase (it complains about LDAP?),
>so
at the moment I use gvib. I've pencilled in quite a bit of time today
>to
try to get kinterbase installed.
Unfortunately I'm on Windows, which I'm guessing contributes to the
installation problems!
but I can confirm that KIinterbaseDA works nicely on Windows - I've
been happily using it for some time, and haven't had any issues at all
(BTW, I don't use LDAP and KInterbaseDA has never mentioned it!). The
only problem I had at install time was getting my head around the
distinction between the Python part and the Zope DA part.
HTH
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date: 8/1/2005
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date:
>8/1/2005
>
>>
>>No virus found in this outgoing message.
>>Checked by AVG Anti-Virus.
>>Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date: 8/1/2005
>>
>>
>
>>