Thread: [INTERFACES] C++ Builder (Delphi), ODBC and large objects

[INTERFACES] C++ Builder (Delphi), ODBC and large objects

From
"angg"
Date:
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.






Re: [INTERFACES] C++ Builder (Delphi), ODBC and large objects

From
"Andrzej Szydlo"
Date:
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

Re: [INTERFACES] C++ Builder (Delphi), ODBC and large objects

From
Sergio
Date:
"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