Srinivas_Vengala
asked on
Connecting to MySQL from SSAS 2008 Project
I am trying to connect to MySQL database from an SSAS 2008 project using MySql.Data.MySqlClient (MySQL Connector Net 6.1.2). I am able to create a datasource pointing to the MySQL database in BIDS successfully. But when I try to create a DSV based on that datasource by including a table from the underlying MySQL database, I am getting the attached error. Can someone please let me know the reason for this issue?
MySQLError.JPG
MySQLError.JPG
ASKER
SSAS 2008 Supports only OLEDB and dotNet providers. I can't use ODBC.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Closing this abandoned question to post a new question.
this may also help you
http://www.devart.com/dotconnect/mysql/editions.html