Add-Ons & Services

ODBC issue

Please post support and help requests here.

ODBC issue

Postby urafajna » 14 Jun 2013, 16:42

I believe there is an ODBC problem in POCO.

The problem is that POCO doesn’t handle correctly fields for which the column size is not defined. (See the ‘ODBCMetaColumn::getDescription()’ function.) For example: size for fields with type 'nvarchar(MAX)' is not determined. When SQLDescribeCol is called for a field with type 'nvarchar(MAX)', the ColumnSizePtr property is 0 (0 – in that case means that the field size is not determined). When POCO calls SQLDescribeCol to determine the field size based on ColumnSizePtr, it incorrectly assumes that 0 is the actual size of the field.

A workaround would be to change the field type from nvarchar(MAX) to something like nvarchar(1024).
Posts: 1
Joined: 11 May 2011, 17:02

Re: ODBC issue

Postby alex » 14 Jun 2013, 19:05

Given that we do not get involved with SQL parsing (and even if we did, pre-allocating few GB of memory is not a smart thing to do), I'm not sure how to adress this.
Posts: 1132
Joined: 11 Jul 2006, 16:27
Location: United_States

Return to Support

Who is online

Users browsing this forum: gregee123 and 1 guest