25 August, 2008

MS AS 2000 and MySQL ODBC Problem

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.

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.

Hope this experience may help some of you who need to do the same thing as I did.

Feris Thia

No comments: