> 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
> "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.
When I read threads like this, it makes me wish I know postgresql a whole lot better. :)
Richard Broersma Jr.
In response to
pgsql-odbc by date
|Next:||From: Greg Nissen||Date: 2007-01-10 01:19:57|
|Subject: auto fill the missing numbers|
|Previous:||From: Grahame Jordan||Date: 2007-01-09 03:10:49|
|Subject: ODBC and Boolean|