[unixODBC-support] Solid, unixODBC & mxODBC: Restricted data type attribute violation
nick.gorham at easysoft.com
Tue Nov 8 16:12:18 GMT 2005
Michal Vitecek wrote:
> hello everyone,
> i'm in the process of trying to use unixODBC in between the Solid
> database engine and the mxODBC (python extension which adds ODBC
> support). the problem is that i'm unable to retrieve values of columns
> which are defined as 'VARCHAR(262144)' (256KB) and get the following
> Traceback: ProgrammingError ('07006', -1, '[unixODBC]Restricted data
> type attribute violation', 3326): from [snip]
> when i try to retrieve the column values via isql all i get is empty
> strings for the column (all other columns of different types are okay).
> what shall i do to get around this?
> thank you,
At first sight I would guess you are asking the driver for a column in a
type it doesn't understand.
isql doesn't show long fields so that may be the problem. A ODBC trace
would at least show what mxODBC is asking the driver to do.
More information about the unixODBC-support