Mysql Connection Error

20 views
Skip to first unread message

loalvares

unread,
Sep 29, 2011, 1:49:27 PM9/29/11
to DataTime Reporting Solution - Business A nalytics, ROLAP, Web Reports, Dashboards, DataWarehouse integration, Slice & Dice
Hi guys,

I`m trying to connect to mysql installed on EasyPHP.
When connect to database, i`m getting the follow error:



Could not connect to DBMS

Connection string:
Provider=MySQLProv;User
ID=root;Password=<YourPassword>;Location=localhost;Data Source=cnai
The 'MySQLProv' provider is not registered on the local machine.


I`ve used others tools and the connection was successful.

thanks

tommaso....@gmail.com

unread,
Sep 29, 2011, 2:19:12 PM9/29/11
to DataTime Reporting Solution - Business A nalytics, ROLAP, Web Reports, Dashboards, DataWarehouse integration, Slice & Dice

Make sure you have a registered the OLE DB provider (must be oled db).

The provider also needs to support the .NET OLE DB schema GUID to be
fully usable by the Rolap system.

Looks like that some "open source" provider are lacking that support.
(No problem instead with sql server, oracle, db2, etc... )


T
Reply all
Reply to author
Forward
0 new messages