Recently, I'm using MySQL as OLAP data staging and development database server for one of my clients which use Microsoft Analysis Server 2000.
I encountered problem with recent MySQL ODBC driver (5.1) from MS AS 2000 trying to get list of tables from MySQL DSN data source.
![](http://3.bp.blogspot.com/_ofnZnO0EGzU/SLLhLG1G5YI/AAAAAAAAAZY/OO7lzSngZ4c/s400/ms_analysis_wizard_mysqlodbc5_1.png)
I then download and install an older version of MySQL driver (3.51) and set new ODBC DSN and finally have it recognized by MS Analysis Server 2000.
![](http://3.bp.blogspot.com/_ofnZnO0EGzU/SLLiE2sD8eI/AAAAAAAAAZg/6oeaXCMjqe8/s400/ms_analysis_wizard_mysqlodbc3_1.png)
![](http://1.bp.blogspot.com/_ofnZnO0EGzU/SLLicWazDSI/AAAAAAAAAZo/no5QR8AgljE/s400/ms_analysis_wizard_mysqlodbc3_1_detail.png)
Hope this experience may help some of you who need to do the same thing as I did.
Feris Thia
No comments:
Post a Comment