MySQL DSN is not displayed in the list of system data source names for Microsoft SSRS using Visual Studio 2010

[ADITYA SHARMA AYYAGARI]

I was trying to establish connection between MySQL database with SSRS using Visual Studio 2010.

I had created a system DSN using MySQL database and when we are trying to fetch the same in list of system data source names under path:

Shared Data Sources>> Add New Data Source >> ODBC>> Edit>> Use new or system data source name,

the DSN created is not displayed additionally, all the DSNs' which have been created using MySQL are not displayed.

I tried with connector versions 6.9x,6.6.5 and also installed MySQL for Visual Studio 1.2.6., but still we are facing the same issue.



Please provide some explanation and solution asap.

Thanks in advance.

Aditya Sharma Ayyagari
HTC Global Services