Solved TD-23684: Error 20057 "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index " on type NVARCHAR(MAX)

Post found bugs and possible workarounds.
Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 3437
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

TD-23684: Error 20057 "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index " on type NVARCHAR(MAX)

Post by Dave Rabelink » 30 Aug 2017, 10:37

Article ID: KB6681218
TD-23684: Error 20057 "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index " when selecting a column of type NVARCHAR(MAX)

Applies to
Gupta Team Developer (TD) 6.3.9, 7.0.2

Summary
When selecting a column of type NVARCHAR(MAX), Error 20057 "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index " might appear.

Workaround
Make sure your SQL.INI longbuffer value is >= 65535.

Cause
SQL.ini longbuffer setting < 65535, default being 32000 when not set in the SQL.INI.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 3437
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: TD-23684: Error 20057 "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index " on type NVARCHAR(MAX)

Post by Dave Rabelink » 21 Jun 2018, 19:29

This defect is fixed in TD 6.3.10
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 2 guests