hello all,
Before migration(v.10.2) we were using one datasource linked to Microsoft OLE DB.
Now in ICA(v.11.0.6) since we dont have OLE DB AS datasource, i tried setting up connection with Microsoft Native Client but its unsuccessful.
Can anyone suggest me how should i connect to OLE DB in ICA v.11.0.6
Thanks!
Quote from: nsaxena on 05 Jun 2017 08:11:56 AM
hello all,
Before migration(v.10.2) we were using one datasource linked to Microsoft OLE DB.
Now in ICA(v.11.0.6) since we dont have OLE DB AS datasource, i tried setting up connection with Microsoft Native Client but its unsuccessful.
Can anyone suggest me how should i connect to OLE DB in ICA v.11.0.6
Thanks!
Do you have the SQL Server native client libraries installed on the server running Cognos Analytics? What error is reported from your connection?
MF.
Hi, Yes, we do have sql libraries installed.
Quote from: nsaxena on 07 Jun 2017 11:44:37 AM
Hi, Yes, we do have sql libraries installed.
What error is reported from your connection?
Hi MFGF, one of the drivers were missing .We locate that and fixed.Its working fine now.
As usual your solutions are perfect. thanks again!