This is a migrated thread and some comments may be shown as answers.

Telerik Report with MySql gives error

2 Answers 264 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Farah
Top achievements
Rank 1
Farah asked on 06 Aug 2014, 06:22 AM
Hello,

I am new to telerik and using telerik report designer (standalone) v8.1.14.804 
When i try to connect to MySql using the connection string: Server=localhost;Database=dbname;Uid=username;Pwd=pass;
i get this error:
Failed to find or load the registered .net framework data provider.

Please note that i have installed mysql .net connector.

Please advise.
Regards.

2 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 06 Aug 2014, 08:54 AM
Hi Farah,

The SqlDataSource component uses standard ADO.NET objects and the installed on the machine data providers to establish a connection to the specified in the connection string database and to retrieve data.

The used data provider must be properly installed and registered on the machine. Also it must be considered with the target platform for the application (x86, AnyCPU). For more details check the Data provider is missing in the SqlDataSource wizard KB article.


Let us know if you have any further questions.

Regards,
Stef
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Farah
Top achievements
Rank 1
answered on 06 Aug 2014, 10:44 AM
I fixed the issue by adding the dll:
C:\Program Files\MySQL\MySQL Connector Net 6.8.3\Assemblies\v4.0\MySql.Data.dll
to Telerik folder.
Tags
Report Designer (standalone)
Asked by
Farah
Top achievements
Rank 1
Answers by
Stef
Telerik team
Farah
Top achievements
Rank 1
Share this question
or