ODBC and Boolean

Hi,

I am using postgres8.1 on a Debian etch machine and am trying to port an
access database to postgres. I have installed the latest ODBC driver on
WinXP (psqlodbc-08_02_0200.zip) and most things work OK.

The most problematic are the checkboxes. At first they work OK but after a
while when setting a checkbox we get an error that seems to keep on
happening.

"The field is too small to accept the amount of data you attempted to add. Try
inserting or pasting less data"

Once it gets in this state it seems to stick. Even tried rebooting.
I believe that the query is not getting past the ODBC driver as I can see no
activity on the back end.


Any help appreciated.

--
Grahame Jordan
Glass Expansion
15 Batman St
West Melbourne
VIC 3003
PH: +61 3 9320 1111
FAX: +61 3 9320 1112

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: ODBC and Boolean

> I am using postgres8.1 on a Debian etch machine and am trying to port a=
n=20
> access database to postgres. I have installed the latest ODBC driver o=
n=20
> WinXP (psqlodbc-08_02_0200.zip) and most things work OK.
>=20
> The most problematic are the checkboxes. At first they work OK but aft=
er a=20
> while when setting a checkbox we get an error that seems to keep on=20
> happening.
>=20
> "The field is too small to accept the amount of data you attempted to a=
dd. Try=20
> inserting or pasting less data"
>=20
> Once it gets in this state it seems to stick. Even tried rebooting.
> I believe that the query is not getting past the ODBC driver as I can s=
ee no=20
> activity on the back end.

I used the recommendation from this link and ever since I have not had an=
y problems linking
boolean fields to checkboxes.
http://archives.postgresql.org/pgsql-odbc/2006-09/msg00103.p hp

When I read threads like this, it makes me wish I know postgresql a whole=
lot better. :)

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: ODBC and Boolean

Richard Broersma Jr wrote:
>> I am using postgres8.1 on a Debian etch machine and am trying to port an
>> access database to postgres. I have installed the latest ODBC driver on
>> WinXP (psqlodbc-08_02_0200.zip) and most things work OK.
>>
>> The most problematic are the checkboxes. At first they work OK but after a
>> while when setting a checkbox we get an error that seems to keep on
>> happening.
>>
>> "The field is too small to accept the amount of data you attempted to add. Try
>> inserting or pasting less data"
>>
>> Once it gets in this state it seems to stick. Even tried rebooting.
>> I believe that the query is not getting past the ODBC driver as I can see no
>> activity on the back end.
>>
>
> I used the recommendation from this link and ever since I have not had any problems linking
> boolean fields to checkboxes.
> http://archives.postgresql.org/pgsql-odbc/2006-09/msg00103.p hp
>
> When I read threads like this, it makes me wish I know postgresql a whole lot better. :)
>
> Regards,
> Richard Broersma Jr.
>

Thanks for that. The problem was that we didn't refresh the tables. All
well now.

Cheers

Grahame
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org