Re: How to connect Reporting Services to MySQL Databases

[Olivier Gaumond]

I had a few problems but I finnally managed to make all that work. I had to use an ODBC system DSN and set some options of the MyODBC driver.

However, my queries with the views created on the link server are very slow. MSSQL doesn't seem to be able to use any of the indexes because the execution plan shows 'remote scan'.

The same query sent directly through the ODBC driver is much more efficient. Any ideas to improve performance? Because right now I have to stick with using ODBC as my report data source.

I tried to create an indexed view, but as I expected it doesn't work with linked servers.

Thanks

Olivier