From: | Wojciech Kromer <krom(at)softomat(dot)com(dot)pl> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Cc: | byronn(at)insightdist(dot)com |
Subject: | [INTERFACES] type error inserting large obj, Win32 ODBC |
Date: | 1999-03-29 16:19:01 |
Message-ID: | 36FFA7F5.3420F13B@softomat.com.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> 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(at)softomat(dot)com(dot)pl
From | Date | Subject | |
---|---|---|---|
Next Message | James Olin Oden | 1999-03-29 16:47:46 | Re: [INTERFACES] Re: I am facing a difficult problem.. |
Previous Message | Wojciech Kromer | 1999-03-29 16:02:56 | Psql ODBC and 'lo' type in PostgreSQL 6.4.x (error inserting large obj...) |