Thread: BUG #5217: (new) error with VB 6.0 SP 6 and psqlODBC 8.4.1

The following bug has been logged online:

Bug reference:      5217
Logged by:          Martin
Email address:      SeaReports@aol.at
PostgreSQL version: 8.4.1
Operating system:   M$ Vista (but does not matter) same on XP, ...
Description:        (new) error with VB 6.0 SP 6 and psqlODBC 8.4.1
Details:

works fine with psqlODBC 8.3.4,
error with psqlODBC 8.4.1

  Sp.CursorType = adOpenDynamic
  Sp.Open "SELECT field1, False :: boolean as Field2 from test LIMIT 1;",
PGSQL_Connection
  Sp!Field2 = "1"   ' <==== error


I can send mylog_3804.log and psqlodbc_3804.log, if someone is interested.

On Fri, Nov 27, 2009 at 8:09 AM, Martin <SeaReports@aol.at> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05217
> Logged by: =A0 =A0 =A0 =A0 =A0Martin
> Email address: =A0 =A0 =A0SeaReports@aol.at
> PostgreSQL version: 8.4.1
> Operating system: =A0 M$ Vista (but does not matter) same on XP, ...
> Description: =A0 =A0 =A0 =A0(new) error with VB 6.0 SP 6 and psqlODBC 8.4=
.1
> Details:
>
> works fine with psqlODBC 8.3.4,
> error with psqlODBC 8.4.1
>
> =A0Sp.CursorType =3D adOpenDynamic
> =A0Sp.Open "SELECT field1, False :: boolean as Field2 from test LIMIT 1;",
> PGSQL_Connection
> =A0Sp!Field2 =3D "1" =A0 ' <=3D=3D=3D=3D error
>
>
> I can send mylog_3804.log and psqlodbc_3804.log, if someone is interested.

Since there has been no response here, I would try reposting this
problem report on pgsql-odbc.  This list is technically for PostgreSQL
bugs proper, and it seems that the pgsql-odbc folks don't follow it
closely.

...Robert