[unixODBC-support] Solid, unixODBC & mxODBC: Restricted data type attribute violation

Nick Gorham 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
> error:
>  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.

Nick Gorham
Easysoft Limited

More information about the unixODBC-support mailing list