We are on 8.1.05. Our DBA added some clustered column store indexes to one of our source databases and now I cannot read that data via Data Migrator. Any suggestions?

This message has been edited. Last edited by: FP Mod Chuck,

Hi Beth

Did you recreate the synonym after the change to the database was made?

Hope all is well with you!

We found the problem.
Our DBA worked with IB Tech Support and did the following:
Installed the Native client from SQL 2012 installation Pack:
https://www.microsoft.com/en-u...etails.aspx?id=50402

Apparently, an important driver was missing.

Hi Chuck, hope all is well with you also! Good to hear from you.

Hi Beth, It's been a couple of years since you posted but maybe you will get this.

On your columnstore issue, were you getting the error about the results being returned in a cursor?

I am having this problem and hope your fix will fix my issue.

Thanks,
John

And Beth, one more question. Was the 'Native client from SQL 2012' installed on your WebFocus Reporting Server?

Johnh

I have not seen Beth on FP for quite a while but I used to be the TAM there. I can't speak to the exact error, but the native client was installed on the reporting server.