Print Page - data source creation

Title: data source creation
Post by: pooja on 12 Mar 2013 11:11:42 AM

Hi all,
need a help on creating new data source in cognos connection with sql server backend. Not sure what information should go on below-

ODBC data source-?
ODBC connect string-?
Collation sequence-?

much appreciate your help.

P.

Title: Re: data source creation
Post by: cognostechie on 12 Mar 2013 05:08:34 PM

If the DB is on the same network, you don't need to go thru ODBC. Use the 'Microsoft SQL Server (OLE DB)' setting and then specify the Server Name and the DB Name.

Title: Re: data source creation
Post by: pooja on 14 Mar 2013 12:20:48 PM

Thank you do much.

It works perfectly....!!! ;D

COGNOiSe.com - The IBM Cognos Community

Archived Content => Cognos 10 BI Platform => Cognos 10 Administration => Topic started by: pooja on 12 Mar 2013 11:11:42 AM