Cognos 10.2 installed in Redhat 6 connecting to sql server 2008 web server bi

Is it possible to connect Cognos Bi Web Server to the SQL Server 2008 using ODBC Driver 11 for SQL Server(msodbcsql). My Cognos is installed in RedHat linux 6(x64).

I can connect to the sql server with isql -v and in sqlcmd -U -S <server/ip> in a terminal…

Really need some help here I’ve been doing this for 2 months… appreciate any help or advice I receive… Thanks a lot in advance…