SYMPTOM:
An ODBC DSN that has been added manually in the ODBC.ini does not appear in the Strategy ODBC Administrator editor in Strategy Intelligence Server Universal 9.x, nor will it be available for selection in the Strategy DB Query tool.
CAUSE:
In Strategy Intelligence Server Universal 9.x, an ODBC DSN cannot be created directly in the interface through the mstrodbcadx for all databases (see documentation for more information about which databases and what steps to take). A DSN for such a database must be manually added to the odbc.ini file. If the added DSN does not appear for selection after this, a possible reason is that the syntax in the odbc.ini file is incorrect.
ACTION:
Check the odbc.ini file for errors. One possible reason for the DSN not appearing is that newly created DSN names should be listed in the section. If it is missing there, the tool will not be able to find the DSN name and fail to display it although its properties have been defined. The following is an example of how this will appear with a Teradata DSN added to an existing Oracle DSN. For all of the steps and the remaining syntax for the Teradata DSN, refer to the Product Manual - Installation and Configuration Guide.
[ODBC Data Sources] DSN_Name_1=Strategy Wire Protocol ODBC Driver for Oracle DSN_Name_2=Teradata Server [ODBC] Trace=0 TraceFile=odbctrace.out TraceDll=/Path yyy InstallDir=/path xxx IANAAppCodePage=106 UseCursorLib=0 [DSN_Name_1] HostName=xxx SID=s3pp PortNumber=1535 Driver=/Path yyy Description=Strategy 6.0 Wire Protocol ODBC Driver for Oracle ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EnableNcharSupport=0 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 IgnoreODBCTimeStampLiteral=1 LocalTimeZoneOffset= LockTimeOut=-1 ProcedureRetResults=0 UseCurrentSchema=1 [DSN_Name_2] Driver=/Path xxx Description=Server running Teradata V2R5 DBCName=xxx.xx.xxx.xxx SessionMode=Teradata NoScan=Yes RunInQuietMode=Yes StCheckLevel=0 DateTimeFormat=AAA LastUser= Username= Password= Database= DefaultDatabase=xxx
