"Data source name is longer than 32 characters: xxxData_Source_Namexxx"
CAUSE:
The Strategy Connectivity Wizard does not limit the number of characters in a data source name for certain drivers. However, the Microsoft ODBC Data Source Administrator is not compatible with DSNs that are longer than 32 characters.
ACTION:
The name of the DSN needs to be manually shortened to less than 32 characters.
On Unix/Linux machine, the data source information is recorded in the ODBC.ini file, which resides in Strategy install directory. On Windows machines, it is kept in a register file:
For 32 bit system, the path is:
HKEY_LOCAL_MACHINE\SFTWARE\ODBC\ODBC.INI\ODBC Data Sources
For 64 bit system, the path is:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources
All ODBC DSNs are stored in this registry folder. Right-click on the problematic DSN and select 'Modify', then adjust the listed Value name to anything shorter than 32 characters. Hit 'OK'. The user will now be able to access and remove this DSN using the Microsoft ODBC Data Source Administrator without error.
Registry Modification:
WARNING:
Modifying registry values incorrectly may cause serious, system-wide problems that may require the re-installation of Microsoft Windows NT. Any edit of the registry is done at the user`s own risk. Since these are user-initiated changes, they are not covered by any Strategy warranty. If using Microsoft Windows NT, the user should backup the registry and/or update an Emergency Repair Disk (ERD) prior to alterations.
