[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,
>  
>
Hi,

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