DSM

NAVIGATION
CATEGORIES
REFERRENCE
LINKS
  • Blobs in Interbase

    9 answers - 6023 bytes - related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

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

    >
    >>

Re: Blobs in Interbase


max 4000 letters.
Your nickname that display:
In order to stop the spam: 3 + 3 =
QUESTION ON "DSM"

EMSDN.COM