Thread: [INTERFACES] C++ Builder (Delphi), ODBC and large objects
22 .10.1998 Sergio <ser@perio.unlp.edu.ar> wrote: >Hi, >I have another problem with lo, I used the new Insight Odbc >driver and when I try to use the datapump utility of Borland >(Delphi) to migrate paradox tables, when it try to convert >memo fields to large objects it gave an error, wich NOT >happen with the previous version of the driver. >I resolved changing the type of the target field to >varchar. Do you mean you can create a table with a large obect field and insert data there from Delphi? If so couldn't you send me your BDE, ODBC setting and SQLs for creating large object type. Thank you, Mikhail.
Hello Byron, On Wed, 21 Oct 1998 17:53:13 -0400, Byron Nikolaidis wrote: > > I haven't had any success figuring out why Borland products can't write > blobs. Maybe you could send me logfiles of the problems (both sql.log > and psqlodbc.log). We've found out, that the problem is in Delphi itself (and probably other Borland's products as well). Seems that Delphi components responsible for BLOBs handling call BDE incorrectly. We managed to make a workaround by calling BDE API manually instead of using components provided by Borland. It works, but make programming much more complicated, or at least much slower. Unfortunately we are unable to compile this workaround into the components library to fix the problem because Borland/Inprise doesn't provide any source code for this part of their library. Do you think we (PostgreSQL + Borland users) could influence Borland to solve this problem? They only need to include our routines into their library or just make some sorce code available (they released it for many other components in thier library) to allow us to fix it. Andrzej
"angg" <angg@vng.ru> el día Thu, 22 Oct 1998 11:00:32 +0500, escribió: >22 .10.1998 Sergio <ser@perio.unlp.edu.ar> wrote: > >>Hi, >>I have another problem with lo, I used the new Insight Odbc >>driver and when I try to use the datapump utility of Borland >>(Delphi) to migrate paradox tables, when it try to convert >>memo fields to large objects it gave an error, wich NOT >>happen with the previous version of the driver. >>I resolved changing the type of the target field to >>varchar. > >Do you mean you can create a table with a large obect field and insert data >there from Delphi? If so couldn't you send me your BDE, ODBC setting and >SQLs for creating large object type. I mean that the datapump (data migration wizard) try to convert a memo field (from a px table) to lo (I guess asking to the driver) and fail to do it, but when you tell to datapump 'hey, convert the memo fields to varchar' it success. This is not a big problem for me, because the workaround is very easy, but the default behavior is failing. Sergio