MySQL Forums
Forum List  »  Microsoft SQL Server

Re: How to connect Reporting Services to MySQL Databases
Posted by: Olivier Gaumond
Date: December 07, 2007 04:44PM

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.



Options: ReplyQuote

Written By
Re: How to connect Reporting Services to MySQL Databases
December 07, 2007 04:44PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.