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

Nick Gorham nick.gorham at easysoft.com
Tue Nov 8 18:18:03 GMT 2005

Michal Vitecek wrote:

> hello Nick,
>Nick Gorham wrote:
>>Michal Vitecek wrote:
>>>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).
>>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.
> below is the relevant (i think) part of the trace. thank you again.
Not much help, but I think the problem is between the driver and the 
app, the app is binding a null pointer, which I suspect is confusing the 

                        Statement = 0x8298a70            
                        Column Number = 1            
                        Target Type = 1 SQL_CHAR            
                        Target Value = (nil)            
                        Buffer Length = 0            
                        StrLen Or Ind = (nil)

Nick Gorham
Easysoft Limited

More information about the unixODBC-support mailing list