Errors using Query Builder and Object Explorer: Index and count must refer to a location within the buffer. (4224379)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Errors using Query Builder and Object Explorer: Index and count must refer to a location within the buffer.
Description

Toad gives the following error when trying to use Query Builder and Object Explorer to access Teradata views. Error has happened by pasting SQL queries in the Editor as well.
Connection is to a Teradata database using Generic ODBC driver connectivity.
"System.ArgumentOutOfRangeException: Index and count must refer to a location within the buffer.
Parameter name: bytes
Stack trace:
   at System.Text.UnicodeEncoding.GetString(Byte[] bytes, Int32 index, Int32 count)
   at Quest.Toad.NativeOdbc.OdbcDriverManager.GetStringData(OdbcHandle connectionHandle, GETINFOFLAGS flag)
   at Quest.Toad.NativeOdbc.OdbcSupportedSQLInformation.get_Keywords()"
Cause

Generic ODBC driver limitations.
Resolution

Connect using a Teradata Native Client instead of a Generic ODBC driver will resolve the issue.
Additional Information

If native connection gives you a timeout error, verify client version and Toad Data Point's support versions of the client.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title