[egenix-users] Re: [unixODBC-support] Solid, unixODBC & mxODBC: Restricted datatype attribute violation

[Michal Vitecek]

 anyone please? i really need to find a solution for this.

    thank you,
                Michal

Michal Vitecek wrote:
> hello everyone, Marc,
>
> i'm having problems with Solid, unixODBC, mxODBC combo (please read
> below). i originally posted the problem description to unixodbc-support
> list but it seems this is not their problem.
>
> can someone please help how to get around this problem?
>
> i'm using Solid 3.5, mxODBC 2.0.7, unixODBC 2.2.11.
>
>    thank you,
>                Michal
>
>Martin J. Evans wrote:
>>Nick Gorham wrote:
>>>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
>>>>>>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).
>>>>>>    
>>>>>
>>>>>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 
>>>driver
>>
>>and binding a NULL TargetValuePtr and StrLen_Or_Ind is the same as
>>unbinding - I think.
>>
>>>[ODBC][696][SQLBindCol.c][165]
>>>               Entry:
>>>                       Statement = 0x8298a70
>>>                       Column Number = 1            
>>>                       Target Type = 1 SQL_CHAR            
>>>                       Target Value = (nil)            
>>>                       Buffer Length = 0            
>>>                       StrLen Or Ind = (nil)
>>>
>>>
>>Martin
>>_______________________________________________
>>unixODBC-support mailing list
>>unixODBC-support at easysoft.com
>>http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>
>the relevant part of the trace:
>
>[ODBC][696][SQLExecDirect.c][233]
>                Entry:            
>                        Statement = 0x8298a70            
>                        SQL = [SELECT xmlSource FROM scriptSource WHERE scriptId=28][length = 52]
>[ODBC][696][SQLExecDirect.c][496]
>                Exit:[SQL_SUCCESS]
>[ODBC][696][SQLNumResultCols.c][149]
>                Entry:            
>                        Statement = 0x8298a70            
>                        Column Count = 0xbf864c5a
>[ODBC][696][SQLNumResultCols.c][234]
>                Exit:[SQL_SUCCESS]                
>                        Count = 0xbf864c5a -> 1
>[ODBC][696][SQLRowCount.c][166]
>                Entry:            
>                        Statement = 0x8298a70            
>                        Row Count = 0xbf864c54
>[ODBC][696][SQLRowCount.c][237]
>                Exit:[SQL_SUCCESS]                
>                        Row Count = 0xbf864c54 -> -1
>[ODBC][696][SQLDescribeCol.c][231]
>                Entry:            
>                        Statement = 0x8298a70            
>                        Column Number = 1            
>                        Column Name = 0x829ae70            
>                        Buffer Length = 38            
>                        Name Length = 0x829ae96            
>                        Data Type = 0x829ae98            
>                        Column Size = 0x829ae9c            
>                        Decimal Digits = 0x829aea0            
>                        Nullable = 0x829aea2
>[ODBC][696][SQLDescribeCol.c][474]
>                Exit:[SQL_SUCCESS]                
>                        Column Name = [XMLSOURCE]                
>                        Data Type = 0x829ae98 -> 12                
>                        Column Size = 0x829ae9c -> 262144                
>                        Decimal Digits = 0x829aea0 -> 0                
>                        Nullable = 0x829aea2 -> 1
>[ODBC][696][SQLFreeStmt.c][140]
>                Entry:            
>                        Statement = 0x8298a70            
>                        Option = 2
>[ODBC][696][SQLFreeStmt.c][246]
>                Exit:[SQL_SUCCESS]
>[ODBC][696][SQLBindCol.c][165]
>                Entry:            
>                        Statement = 0x8298a70            
>                        Column Number = 1            
>                        Target Type = 1 SQL_CHAR            
>                        Target Value = (nil)            
>                        Buffer Length = 0            
>                        StrLen Or Ind = (nil)
>[ODBC][696][SQLBindCol.c][251]
>                Exit:[SQL_SUCCESS]
>[ODBC][696][SQLFetch.c][158]
>                Entry:            
>                        Statement = 0x8298a70
>[ODBC][696][SQLFetch.c][340]
>                Exit:[SQL_ERROR]
>                DIAG [07006] Restricted data type attribute violation
>
>
>-- 
>		fuf		(fuf at mageo.cz)
>
>
>_______________________________________________________________________
>eGenix.com User Mailing List                     http://www.egenix.com/
>https://www.egenix.com/mailman/listinfo/egenix-users

-- 
		fuf		(fuf at mageo.cz)