Re: Hi! - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Hi!
Date
Msg-id 006e01c33f0f$96eb05b0$3d283ddb@PbgX
Whole thread Raw
In response to Hi!  (Armando Bañuelos <armando@maprono.com.mx>)
List pgsql-odbc
-----Original Message-----
> From: Armando Baelos

>  I'm using your odbc driver and it seems to be ok in almost everything... the only thing I see wrongly is
>  when i´m not using the Microsoft ODBC Engine... when I´m inserting or editing a recordset I always get
>  the same error in the exception but the error en the server console is rigth... I´m using VC 6.0 and the
>  MFC ODBC Classes... a workaround to this is to use transaction to insert but i dislike that workaraound...

Are you checking the "Updatable cursors" option ?
What kind of recordset are you opening ?

>  Other funcionality is about the bytea and the binary objects in VC... The CByteArray only gives me chance
>  of upload/download 254 bytes unless I change the max varchar or set the unknows as LongVarChar...
>  I think you should give the bytea a representation as lo and don't limit as an unknown data type...

Please try to check the "bytea as LongVarBinary" DSN option.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Re: A few problems with the ODBC driver
Next
From: Godshall Michael
Date:
Subject: Error adding table in Crystal Reports(mult. schemas available)