Adding table to a .tsm generates "The identifier that starts with ODBC"," PWD is too long. Maximum length is 128" (4275342)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Adding table to a .tsm generates "The identifier that starts with ODBC"," PWD is too long. Maximum length is 128"
Description

Building query from the Query Builder and it is saved as .tsm in the Project Manager.
After opening up the .tsm and adding a new table into it, the following error is generated:
Incorrect syntax near `.
The identifier that starts with ODBC;DRIVER=SQL Server;SERVER=<SOME_SERVER>\<SOME_INSTANCE>;UID=sa;APP=Toad for Data Analysis Beta;WSID=<SOME_SERVER>;DATABASE=<SOME_DATABASE>;PWD is too long. Maximum length is 128.
Resolution

WORKAROUND:
None

STATUS:
Issue fixed in version 2.0.
The current commercial version can be downloaded at the Support Portal.
Defect ID

ST49072

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title