pass-through query ODBC connect str error? Version: 2003 (11.0)

  • Thread starter Thread starter sk
  • Start date Start date
S

sk

hello,

when trying to fire a pass-through query on a teradata
database, i get the following error:

"ODBC -- call failed.

[NCR] [Teradata RDBMS] Name is longer than 30 characters.
(#-3737)"


when looking at the connect string in the query
properties, it is indeed more than 30 characters (i assume
this is what the "Name" reference is to?) but there is no
way to shorten it given that even the default characters
that have to be in the string (i.e., "ODBC;","DATABASE=",
etc. make up almost 20 of those. i have looked around for
help on #-3737 to no avail. anyone have any ideas on how
to circumvent this error? am i even correct in my
assumption that "Name" in the error is referring to the
connect str?

thanks in advance for your help!
 
The message you're getting is coming from Teradata. This suggests the
problem is with the query you're passing through, not the connect string.
If the problem was with the connect string, you wouldn't be able to connect
to Teradata in the first place.

Check the syntax of your query. It sounds like Teradata has a 30-character
limitation on "names" (presumably of tables, columns, variables, etc.).
 
Back
Top