Microsoft OLE DB connection issue

[nsaxena]

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!

[MFGF]

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.

[nsaxena]

Hi, Yes, we do have sql libraries installed.

[MFGF]

Hi, Yes, we do have sql libraries installed.

What error is reported from your connection?

[nsaxena]

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!