SQL Server Reporting Services - dotConnect not available
SQL Server Reporting Services - dotConnect not available
When I use SSRS I can't find the dotConnect for MySQL option available for my "shared data source".
Is SSRS in Microsoft visual studio 2005 not supported?
I am currently using the trial copy of dotConnect as I'm waiting for the purchase order to get back to me (it's with the head of department).
Is SSRS in Microsoft visual studio 2005 not supported?
I am currently using the trial copy of dotConnect as I'm waiting for the purchase order to get back to me (it's with the head of department).
We cannot reproduce the problem with SSRS 2005 (Report Server Project). I have sent you the screenshot of the Type drop-down list of the Shared Data Source menu on my machine. Do you have the same? Please specify the version of your dotConnect for MySQL (the Tools | MySQL | About menu of Visual Studio). Please give us a more detailed description of the problem.
I don't get any entries for Devart in the 'Type' drop down (unlike the screen shot you sent me).
my dotConnect is: 5.20.29.0
I had a previous issue of Devart.Data.MySql.xsl cartridges not being available for SSAS projects. Could this be the same issue? Where should these cartridges be located for the SSRS projects/software?
I'm using
OS: Windows XP
Visual studio: 8.0.50727.42
SQL server: 2005
my dotConnect is: 5.20.29.0
I had a previous issue of Devart.Data.MySql.xsl cartridges not being available for SSAS projects. Could this be the same issue? Where should these cartridges be located for the SSRS projects/software?
I'm using
OS: Windows XP
Visual studio: 8.0.50727.42
SQL server: 2005
dotConnect for MySQL installation package performs the following actions to make the SSRS support be available:
1) places Devart assemblies at
a) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Devart.Data.MySql.ReportingServices.dll
b) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Devart.Data.MySql.ReportingServices.Design.dll
c) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Devart.Data.MySql.ReportingServices.dll
d) Devart.Data.MySql.ReportingServices.dll (GAC, version 5.20.29.0)
e) Devart.Data.MySql.ReportingServices.dll (GAC, version 5.20.29.1)
2) makes the records with the Devart.Data.MySQL entry to the following files:
a) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config
b) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSReportDesigner.config
c) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config
d) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config
1) places Devart assemblies at
a) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Devart.Data.MySql.ReportingServices.dll
b) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Devart.Data.MySql.ReportingServices.Design.dll
c) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Devart.Data.MySql.ReportingServices.dll
d) Devart.Data.MySql.ReportingServices.dll (GAC, version 5.20.29.0)
e) Devart.Data.MySql.ReportingServices.dll (GAC, version 5.20.29.1)
2) makes the records with the Devart.Data.MySQL entry to the following files:
a) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config
b) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSReportDesigner.config
c) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config
d) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config
Here are the entries from the mentioned files. Please change the paths and assemblies versions to your own.
1) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config
2) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSReportDesigner.config
3) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config
4) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config
1) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config
Code: Select all
<configuration>
<mscorlib>
<security>
<policy>
<PolicyLevel version="1">
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Devart.Data.MySql" Description="Code group for Devart.Data.MySql.ReportingServices data processing extension">
<IMembershipCondition class="UrlMembershipCondition" version="1" Url="D:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Devart.Data.MySql.ReportingServices.dll" />
</CodeGroup>
</PolicyLevel>
</policy>
</security>
</mscorlib>
</configuration>
Code: Select all
<Configuration>
<Extensions>
<Data>
<Extension Name="Devart.Data.MySql" Type="Devart.Data.MySql.ReportingServices.MySqlConnectionWrapper, Devart.Data.MySql.ReportingServices, Version=5.20.29.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</Data>
<Designer>
<Extension Name="Devart.Data.MySql" Type="Devart.Data.MySql.ReportingServices.Design.MySqlQueryDesigner, Devart.Data.MySql.ReportingServices.Design, Version=5.20.29.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</Designer>
</Extensions>
</Configuration>
Code: Select all
<Configuration>
<Extensions>
<Data>
<Extension Name="Devart.Data.MySql" Type="Devart.Data.MySql.ReportingServices.MySqlConnectionWrapper, Devart.Data.MySql.ReportingServices, Version=5.20.29.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</Data>
</Extensions>
</Configuration>
Code: Select all
<configuration>
<mscorlib>
<security>
<policy>
<PolicyLevel version="1">
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Devart.Data.MySql" Description="Code group for Devart.Data.MySql data processing extension">
<IMembershipCondition class="UrlMembershipCondition" version="1" Url="d:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Devart.Data.MySql.ReportingServices.dll" />
</CodeGroup>
</PolicyLevel>
</policy>
</security>
</mscorlib>
</configuration>
I have made those changes and have been able to connect and create reports based from the MySQL database.
However I had to copy the connection string from another project as the button for generating the connection string was disabled in SSRS.
Also I can't seem to get parameters to work properly, either using :param or @param seems to fail at the "Preview" tab.
However I had to copy the connection string from another project as the button for generating the connection string was disabled in SSRS.
Also I can't seem to get parameters to work properly, either using :param or @param seems to fail at the "Preview" tab.