Looking to add MySQL as a datasource for reports.

I am upgrading my RS server to a windows 2003 server and want to use the
MySQL.dll for .NET.
I know that I am able to add custom data sources to the report designer but
have yet to figure it out.
Can someone point me in the right direction with some very good
documentation?
Thanks
KevinDocumentation on the config files:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_8iqq.asp
This should get you started:
* First, you have to make sure the MySQL data provider is installed
correctly, so that the report designer in VS.NET and report server inside
ASP.NET are able to load the dlls of the data provider at runtime. Note:
there could be file system permissions issues which prevent ASP.NET from
accessing the MySQL data provider dlls. You might want to try to copy the
dlls directly into the
report designer and report server installation directories.
* close all VS.NET sessions before modifying rsReportDesigner.config
* backup the existing rsReportDesigner.config and rsReportServer.config
* read the MySQL documentation to find out the type name for the Connection
object which implements IDbConnection. You will need this information when
changing the config files.
* Add these entries to rsReportDesigner.config in the Data section:
<Extension Name="MySQL" Type="***MySql Connection ClassTypeName***,
***AssemblyName***"/>
... and in the Designer section:
<Extension Name="MySQL"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
* Stop the ReportServer Windows service
* Add this entry to rsReportServer.config in the Data section:
<Extension Name="MySQL" Type="***MySql Connection ClassTypeName***,
***AssemblyName***"/>
* Restart ReportServer Windows service
* Reset IIS/ASP.NET by running iisreset from the command line
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin" <k@.r.com> wrote in message
news:OY1LjSz$EHA.2880@.TK2MSFTNGP14.phx.gbl...
> I am upgrading my RS server to a windows 2003 server and want to use the
> MySQL.dll for .NET.
> I know that I am able to add custom data sources to the report designer
but
> have yet to figure it out.
> Can someone point me in the right direction with some very good
> documentation?
> Thanks
> Kevin
>|||Thanks.
It works great.
I am running into a problem with my defined functions. I built a functions
library and have been using it until now so I know it is configured
correctly. I am attempting to convert my reports over but they all use
functions that I have built and I am getting errors returned from the Report
Designer. "Error in SQL Syntax."
Since the MySQL library does work through the report designer. Should the
functions ability also not work as it did with the ODBC driver? I am not
sure of any settings that I might need to check.
Thanks
Kevin
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23nvQTnz$EHA.2568@.TK2MSFTNGP11.phx.gbl...
> Documentation on the config files:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_8iqq.asp
>
> This should get you started:
> * First, you have to make sure the MySQL data provider is installed
> correctly, so that the report designer in VS.NET and report server inside
> ASP.NET are able to load the dlls of the data provider at runtime. Note:
> there could be file system permissions issues which prevent ASP.NET from
> accessing the MySQL data provider dlls. You might want to try to copy the
> dlls directly into the
> report designer and report server installation directories.
> * close all VS.NET sessions before modifying rsReportDesigner.config
> * backup the existing rsReportDesigner.config and rsReportServer.config
> * read the MySQL documentation to find out the type name for the
> Connection
> object which implements IDbConnection. You will need this information when
> changing the config files.
> * Add these entries to rsReportDesigner.config in the Data section:
> <Extension Name="MySQL" Type="***MySql Connection ClassTypeName***,
> ***AssemblyName***"/>
> ... and in the Designer section:
> <Extension Name="MySQL"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
> * Stop the ReportServer Windows service
> * Add this entry to rsReportServer.config in the Data section:
> <Extension Name="MySQL" Type="***MySql Connection ClassTypeName***,
> ***AssemblyName***"/>
> * Restart ReportServer Windows service
> * Reset IIS/ASP.NET by running iisreset from the command line
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Kevin" <k@.r.com> wrote in message
> news:OY1LjSz$EHA.2880@.TK2MSFTNGP14.phx.gbl...
>> I am upgrading my RS server to a windows 2003 server and want to use the
>> MySQL.dll for .NET.
>> I know that I am able to add custom data sources to the report designer
> but
>> have yet to figure it out.
>> Can someone point me in the right direction with some very good
>> documentation?
>> Thanks
>> Kevin
>>
>
>