Unable to Select ODBC as the Type of Data Source Connection

Because IBM® Cognos® software on UNIX does not support all ODBC drivers, when you create data source connections to IBM Red Brick®, Microsoft SQL Server, or NCR Teradata databases, you cannot select ODBC as the type of data source connection.

To create an ODBC connection to these database vendors, select Other Type instead.

For the following database vendors, add the associated database codes when you type the connection string.

Table 1. Database codes used for connections string according to the associated database vendor
Database vendor	Database code
IBM Red Brick	RB
Microsoft SQL Server	SS
NCR Teradata	TD

Type the data source connection, as follows:

[^UserID:[^?Password:]];LOCAL;{RBSSTD};DSN= Data_Source [; UID=%s[;PWD=%s]][@ASYNC={01}][@ Connection_Timeout/ Reply_Timeout ][@COLSEQ=[ Collation_Sequence ]]

The following are examples of connection strings:

^UserID:^?Password:;LOCAL;RB;DSN=DB62SALES;UID=%s;PWD=%s@ASYNC=0
;LOCAL;SS;DSN=TESTSERVER

To create data source connections to Microsoft SQL Server from UNIX, you must use the DataDirect ODBC driver for SQL Server.