Hi ,
I am trying to connect to a sql server 2016 database from cognos data source .
I have the native client chosen and entered the credentials along with jdbc checked .
I have the results as native client logon failed and
JDBC succeded .
Wjat does that mean can the cognos still write or read from the sql using jdbc
How do I make the native client also work .
In the drivers of cognos installation i have sqljdbc42.jar . For native client to work should i install other drivers .
Thanks,
Quote from: nithya1224 on 07 Mar 2018 09:54:20 AM
Hi ,
I am trying to connect to a sql server 2016 database from cognos data source .
I have the native client chosen and entered the credentials along with jdbc checked .
I have the results as native client logon failed and
JDBC succeded .
Wjat does that mean can the cognos still write or read from the sql using jdbc
How do I make the native client also work .
In the drivers of cognos installation i have sqljdbc42.jar . For native client to work should i install other drivers .
Thanks,
Hi,
For the native client to work you need to install the SQL Server Native Client libraries on the server.
Cheers!
MF.
Can you send me the download link on what exactly I should download .
Quote from: nithya1224 on 07 Mar 2018 11:38:17 AM
Can you send me the download link on what exactly I should download .
Hi,
It's part of the SQL Server install
https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client
MF.