Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: aopinto on 10 Nov 2016 06:40:31 AM

Title: Is it possible use SQL Server Native Client 64 bits
Post by: aopinto on 10 Nov 2016 06:40:31 AM
Hi folks,

I am new here and I have a doubt about using a SQL Server database as a Cognos Data Source.

Can I install the SQL Server Native Client 64 bits on report server or only 32 bits ?

Thanks
Title: Re: Is it possible use SQL Server Native Client 64 bits
Post by: MFGF on 11 Nov 2016 03:34:39 AM
Quote from: aopinto on 10 Nov 2016 06:40:31 AM
Hi folks,

I am new here and I have a doubt about using a SQL Server database as a Cognos Data Source.

Can I install the SQL Server Native Client 64 bits on report server or only 32 bits ?

Thanks

If you want to connect to SQL Server using the native client, you need the 32-bit native client libraries installed on the Cognos server. If you want to connect to SQL Server via JDBC, you simply need the class 4 jdbc driver copying to the Cognos server.

MF.
Title: Re: Is it possible use SQL Server Native Client 64 bits
Post by: sdf on 20 Nov 2016 07:35:58 PM
go for the latter ^^^. you'll need jdbc for dqm.
Text only | Text with Images