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
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.
Peter
the Telerik team