Return
-
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.