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

MySQL Connection issue using Reporting

1 Answer 117 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Michael
Top achievements
Rank 1
Michael asked on 08 Feb 2011, 08:39 PM
Hi,

We are facing one problem in telerik  reporting, we are unable to connect mysql database using mysql odbc client when we deploy application with IIS but when we run application using visual studio n with local web server it works fine, can you please guide us what can be the resolution of this problem.

Regards,
Shirjeel

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 09 Feb 2011, 05:04 PM
Hi Michael,

This is all about configuring your ODBC data source. The single reason for a problem if everything is working fine on the development machine, is if you have not configured the data source properly. Should we assume that you've setup the same connection on the server (as on the dev machine) through Administrative Tools --> Data Sources (ODBC)? Please try wiring up a standard DataGridView control to the same data base connection on the server and see if that works for you - this would indicate whether it is set-up properly. About the error you received, after some googling, we found the following article (http://technet.microsoft.com/en-us/library/cc917587.aspx) where it is stated:

"make sure the data source name was defined using the same Microsoft Windows account the application is running under, or it is a system data source"

Basically it says that adding exactly the same DSN to the System DSN section should fix the problem.

Best wishes,
Peter
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
Tags
General Discussions
Asked by
Michael
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or