From: Wojciech Kromer <krom@softomat.com.pl>
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com
Subject: [INTERFACES] type error inserting large obj, Win32 ODBC
Date: Mon, 29 Mar 1999 18:19:01 +0200
Message-ID: <36FFA7F5.3420F13B@softomat.com.pl> (raw)
> Re: [INTERFACES] type error inserting large obj, Win32 ODBC
>
> Sam O'Connor wrote:
>
> > I'm having a problem getting large objects to work with the IDS ODBC
> > driver from MS VC++.
> > I'm Using the MFC CRecordset class to talk to the ODBC driver.
> > When I try to add a record with a large object stored in a CLongBinary
> > I get the message below ( see dbms output). If I dont flag the column as
> > dirty and not NULL, causing the blob to be ignored, the rest of the row
> > gets updated properly. When I do flag the blob dirty and not NULL then
> > the driver returns SQL_NEED_DATA in the MFC code and causes
> > SendLongBinaryData to be called. This sends all the data through then
> > just before exiting calls SQLParamData again which fails with the error
> > message.
> > Below is the error message, the MS code, my setup info and my code.
> > If anyone can point out what I am doing wrong I would greatly appreciate
> > it.
> > If anyone has a completly different better way to do it that would be
> > just as good.
> > Some working example code would be best of all.
> > (If any extra information would be useful I'd be happy to provide it.)
> > Thanks
> > Sam O'Connor
> >
> > ---- dbms output ----
> >
> > ERROR: parser: attribute 'bitmap' is of type 'lo' but expression is of
> > type 'int4'
> > You will need to rewrite or cast the expression (1)
> >
>
> Please send the driver log which shows the query that is generating the
> above failure. Either the driver's commlog or the odbc trace log would do.
> The more info the better.
>
> BTW, I have tested the driver with large objects in MS Access and it seems
> to work fine -- I can send and receive OLE objects from/to the database.
> So, perhaps its something in MFC that needs to be tweeked.
>
> Byron
>
> ------------------------------------------------------------------------
Please publish or send me the patched compiled version of psqlodbc.dll,
I dont have the Microsoft C...
--
%%
Kazda cywilizacja musi dojsc do momentu, w ktorym wymysli PIWO!
%%
Wojciech Kromer mailto:krom@softomat.com.pl
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: krom@softomat.com.pl, byronn@insightdist.com
Subject: Re: [INTERFACES] type error inserting large obj, Win32 ODBC
In-Reply-To: <36FFA7F5.3420F13B@softomat.com.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox