Connector not available from SSRS

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
rbb555
Posts: 7
Joined: Fri 16 Apr 2010 01:37

Connector not available from SSRS

Post by rbb555 » Fri 16 Apr 2010 01:42

We've just purchased and installed the connector but it is not listed in the available connectors in ReportServer.

It IS however available in integration services.

Following the logic of a reply to a similar post (but for MySQL) we tried to manually add the Extension to the rsreportserver.config file, but we're guessing as to what exactly needs to be added. We used the following with no luck, using:



- where we copied the version, culture and token from the Devart.Data.PostgreSql XML file itself.

Is this the right approach, or is there more we need to do?

Thanks in advance,

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 20 Apr 2010 13:42

Please give us the following information:
1) the exact version (x.xx.xx) and edition of your dotConnect for PostgreSQL. You can find it in the Tools | PostgreSQL | About menu of Visual Studio. Note that the SQL Server Business Intelligence Solutions support is not available in the Express and Standard editions;
2) the version of your Visual Studio;
3) were there any errors during installation of dotConnect for PostgreSQL? Please try to uninstall and install it again with the /log option. For example:
dcpostgresql485pro.exe /log=C:\installlog.txt

Are there any errors in this log file?
4) You refered in your post to another thread at our forum. Did you mean this thread: http://www.devart.com/forums/viewtopic.php?t=14895 ? Please check the paths mentioned in that thread for the dotConnect for PostgreSQL entries.

rbb555
Posts: 7
Joined: Fri 16 Apr 2010 01:37

Post by rbb555 » Wed 21 Apr 2010 07:29

Thanks for your response.
1) Devart dotConnect for PostgreSQL 4.90.124.0

2)
MS Version details
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: IDE Standard

SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 10.0.2531.0

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )

SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 10.0.2531.0

This is a vanilla MSSQL2008 box - everything has been installed with default options.

Let me know if you need to know about all the hotfixes.


3) I've reinstalled as you suggested with no luck finding the dotConnector in SSRS. How do I post it back in this forum? There are no errors that I can see in the install log.

4) Yes, that was the post I was looking at. I've checked the locations you mentioned in that post with the following results:

1) Devart assemblies at
a) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Devart.Data.MySql.ReportingServices.dll
NOT in \Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\

b) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Devart.Data.MySql.ReportingServices.Design.dll
NOT in \Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\

c) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Devart.Data.MySql.ReportingServices.dll
NOT IN \Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin\but other Devart assemblies are there (i.e. I checked for Devart.Data.PostgreSql.ReportingServices.dll)

d) Devart.Data.MySql.ReportingServices.dll (GAC, version 5.20.29.0)
YES, but obviously Devart.Data.PostgreSQL.ReportingServices version 4.90.124.1

e) Devart.Data.MySql.ReportingServices.dll (GAC, version 5.20.29.1)
NO ? assume this is N/A

2) entries in the following files:
a) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config
NO such file - only file by that name is in \Program Files (x86)\Microsoft SQL Server\Report Builder 2.0\ but this has no devart entry there either

b) \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSReportDesigner.config
NO such file - only file by that name is in \Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\ but this has no devart entry there either

c) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config
NO (file is there but no devart entry)

d) \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config
NO (file is there but no devart entry)

Thanks again for your help

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 23 Apr 2010 14:00

SQL Server Reporting Services x86 on the x64 machine should work. We will investigate the issue and notify you about the results.

SQL Server Reporting Services x64 are not supported.

rbb555
Posts: 7
Joined: Fri 16 Apr 2010 01:37

Post by rbb555 » Thu 29 Apr 2010 00:43

Thanks again,

Just FYI for anyone following this, Alex emailed me for the following information:

1) The install was SQL Server 2008 Standard Edition SP1 x64.

2) I have a key named:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10.MSSQLSERVER

, but there is no key named:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10

Cheers

rbb555
Posts: 7
Joined: Fri 16 Apr 2010 01:37

Tried x86 install with no luck

Post by rbb555 » Thu 29 Apr 2010 23:54

We've tried the following:
1. uninstalled SQL Server x64,
2. reinstalled x86,
3. uninstalled .NET connector professional, and
4. reinstalled .NET connector professional, in that order.

No change.

We are still able to use the .NET connector for SSIS type projects, but not Reporting Services.

Anything else we can try?

Also, could you please advise when you're likely to support x64 as more applications are appearing which do not support x86 databases, and we're guessing that the next major release of SQL Server will be only x64.

Many thanks

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 30 Apr 2010 14:18

We have fixed the issue with SQL Server Reporting Services x86 on the x64 machine. The fix will be included to the next builds of dotConnects. As a temporary workaround with the current build, please add these entries to the following *.config files (our installation copied the necessary assemblies correctly, the only problem is this entries):

1) open the C:\Program Files (x86)\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config file with the text editor and add this fragment:

Code: Select all

<Configuration>
  <Extensions>
    <Data>
      <Extension Name="Devart.Data.PostgreSql" Type="Devart.Data.PostgreSql.ReportingServices.PostgreSqlConnectionWrapper, Devart.Data.PostgreSql.ReportingServices, Version=4.90.130.1, Culture=neutral, PublicKeyToken=09af7300eec23701" />
    </Data>
  </Extensions>
</Configuration>
2) open the C:\Program Files (x86)\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rssrvpolicy.config file with the text editor and add this fragment:

Code: Select all

<configuration>
  <mscorlib>
    <security>
      <policy>
          <PolicyLevel>
             <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Devart.Data.PostgreSql" Description="Code group for Devart.Data.PostgreSql data processing extension">
               <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files (x86)\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin\Devart.Data.PostgreSql.ReportingServices.dll" />
             </CodeGroup>
          </PolicyLevel>
      </policy>
    </security>
  </mscorlib>
</configuration>
If necessary, we can send you the rsreportserver.config and rssrvpolicy.config files from our environment (not for replacing your own files with these ones, but for example of adding the metioned entries).

Please notify us if the problem is resolved with SQL Server Reporting Services x86.

We are working on adding support for SQL Server Reporting Services x64.

rbb555
Posts: 7
Joined: Fri 16 Apr 2010 01:37

rssrvpolicy.config

Post by rbb555 » Thu 06 May 2010 00:02

Could you check the second stanza? In our config file there appears to be another level of tag. I'll responded with our file by email to Alex. It may be that our file is dodgy.

Either way, we tried both arrangements but with no luck. We also tried on another PC with the same MS SQL Server install. Still no luck.

We can still use the connector through SSIS but not through Reportng Services - the method of connection just isn't available - the connection wizard drop-down only offers "SqlClient Data Provider" and "OracleClient Data Provider".

We do appreciate your efforts.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 12 May 2010 16:52

We will send you internal build with the fix to check its workability during 2 working days.

rbb555
Posts: 7
Joined: Fri 16 Apr 2010 01:37

Thanks

Post by rbb555 » Thu 13 May 2010 23:03

Thanks Alex, much appreciated.

rbb555
Posts: 7
Joined: Fri 16 Apr 2010 01:37

No luck - giving up for now and hoping new versions will fix

Post by rbb555 » Tue 15 Jun 2010 07:09

We've checked the files again but had no luck with this. We'll wait with our fingers crossed for the next version and hope that resolves the issue.

:?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 15 Jun 2010 12:36

Please explain "had no luck with this":
1) you have mentioned in your e-mails that you had reinstalled SSRS several times. Do you have \Program Files (x86)\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config and \Program Files (x86)\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rssrvpolicy.config files now in your environment?
2) do these files contain the entries mentioned above? If not, please add them manually;
3) have you tried the latest (4.95.140) version of dotConnect for PostgreSQL?

Scott Herbert
Posts: 3
Joined: Tue 31 Aug 2010 05:25
Location: Canberra, Australia

Post by Scott Herbert » Tue 31 Aug 2010 06:29

I'm having similar problems to what's being described above.

Dotconnet works great in SSIS 2008, however I'm unable to find any dotconnect provider in Report Builder 3.0 or the 2008 BI Studio when attempting to create a Report Model project.

I have installed the pro version of 4.95.152. I am using SQL Server 2008 R2.

Devart.Data.PostgreSql.ReportingServices.dll exists in the C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin directory.

After installation of dotconnect, there were no mentions of any devart information in the rsreportserver.config or rssrvpolicy.config files in C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer.

So, following the posts earlier in this thread, I've made some additions:

rsreportserver.config looks like:

......

Code: Select all

<Configuration>
   <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAADEtEGvvPFkicGKvbWqAW7gQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAANd8Sp8rxkpSvdJYqb6ScAMAAAAA
BIAAAKAAAAAQAAAAyWIbbHkPnkAUEXNwgrUIA+AAAADxiUx4enC1MJWaFBZJVJ4QPS0kkTgzPYMG
Vd8VoFKGzW4t2gY7vUsqUHx2urZx/nIQLeuOE4Nbq30U8f79bXpuznLMLZBXE9KoN7cePKsK9DWg
tFoGbGkW93ylB6feJyCdtNsa8Dbdg052uenmKHluvBB59QytJ80mqn6xwRwdlZaPynKvThi6Hju9
G+k4Y4f+MHBkIIfC39yzGuMU/iWTVFT3ClDZbV9/rlsxe6DFGW2xVVHePK6/ZZmKx/vYM/nCWFxq
zwzJL/Ox/rp/46OaxxCr42P78mstzqn+sHpuPhQAAAA4wbgJURluwnPpXTtB/9OdgBK6nQ==</Dsn>
   <ConnectionType>Default</ConnectionType>
   <LogonUser></LogonUser>
   <LogonDomain></LogonDomain>
   <LogonCred></LogonCred>
   <InstanceId>MSRS10_50.MSSQLSERVER</InstanceId>
   <InstallationID>{1e97f7ce-c671-496b-b6c8-1bd837d2993c}</InstallationID>
   <Add Key="SecureConnectionLevel" Value="0"/>
   <Add Key="CleanupCycleMinutes" Value="10"/>
   <Add Key="MaxActiveReqForOneUser" Value="20"/>
   <Add Key="DatabaseQueryTimeout" Value="120"/>
   <Add Key="RunningRequestsScavengerCycle" Value="60"/>
   <Add Key="RunningRequestsDbCycle" Value="60"/>
   <Add Key="RunningRequestsAge" Value="30"/>
   <Add Key="MaxScheduleWait" Value="5"/>
   <Add Key="DisplayErrorLink" Value="true"/>
   <Add Key="WebServiceUseFileShareStorage" Value="false"/>
   <!--  <Add Key="ProcessTimeout" Value="150" /> -->
   <!--  <Add Key="ProcessTimeoutGcExtension" Value="30" /> -->
   <!--  <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
   <!--  <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
   <!--  <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
   <Add Key="WatsonFlags" Value="0x0428"/>
   <Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException"/>
   <Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException"/>
   <URLReservations>
      <Application>
         <Name>ReportServerWebService</Name>
         <VirtualDirectory>ReportServer</VirtualDirectory>
         <URLs>
            <URL>
               <UrlString>http://+:8080</UrlString>
               <AccountSid>S-1-5-18</AccountSid>
               <AccountName>LocalSystem</AccountName>
            </URL>
         </URLs>
      </Application>
      <Application>
         <Name>ReportManager</Name>
         <VirtualDirectory>Reports</VirtualDirectory>
         <URLs>
            <URL>
               <UrlString>http://+:8080</UrlString>
               <AccountSid>S-1-5-18</AccountSid>
               <AccountName>LocalSystem</AccountName>
            </URL>
         </URLs>
      </Application>
   </URLReservations>
   <Authentication>
      <AuthenticationTypes>
         <RSWindowsNegotiate/>
         <RSWindowsNTLM/>
      </AuthenticationTypes>
      <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
      <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
      <EnableAuthPersistence>true</EnableAuthPersistence>
   </Authentication>
   <Service>
      <IsSchedulingService>True</IsSchedulingService>
      <IsNotificationService>True</IsNotificationService>
      <IsEventService>True</IsEventService>
      <PollingInterval>10</PollingInterval>
      <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
      <MemorySafetyMargin>80</MemorySafetyMargin>
      <MemoryThreshold>90</MemoryThreshold>
      <RecycleTime>720</RecycleTime>
      <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
      <MaxQueueThreads>0</MaxQueueThreads>
      <UrlRoot>
      </UrlRoot>
      <UnattendedExecutionAccount>
         <UserName></UserName>
         <Password></Password>
         <Domain></Domain>
      </UnattendedExecutionAccount>
      <PolicyLevel>rssrvpolicy.config</PolicyLevel>
      <IsWebServiceEnabled>True</IsWebServiceEnabled>
      <IsReportManagerEnabled>True</IsReportManagerEnabled>
      <FileShareStorageLocation>
         <Path>
         </Path>
      </FileShareStorageLocation>
   </Service>
   <UI>
      <ReportServerUrl>
      </ReportServerUrl>
      <PageCountMode>Estimate</PageCountMode>
   </UI>
   <Extensions>
      <Delivery>
         <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
            <MaxRetries>3</MaxRetries>
            <SecondsBeforeRetry>900</SecondsBeforeRetry>
            <Configuration>
               <FileShareConfiguration>
                  <ExcludedRenderFormats>
                     <RenderingExtension>HTMLOWC</RenderingExtension>
                     <RenderingExtension>NULL</RenderingExtension>
                     <RenderingExtension>RGDI</RenderingExtension>
                  </ExcludedRenderFormats>
               </FileShareConfiguration>
            </Configuration>
         </Extension>
         <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
            <MaxRetries>3</MaxRetries>
            <SecondsBeforeRetry>900</SecondsBeforeRetry>
            <Configuration>
               <RSEmailDPConfiguration>
                  <SMTPServer></SMTPServer>
                  <SMTPServerPort>
                  </SMTPServerPort>
                  <SMTPAccountName>
                  </SMTPAccountName>
                  <SMTPConnectionTimeout>
                  </SMTPConnectionTimeout>
                  <SMTPServerPickupDirectory>
                  </SMTPServerPickupDirectory>
                  <SMTPUseSSL>
                  </SMTPUseSSL>
                  <SendUsing>2</SendUsing>
                  <SMTPAuthenticate>
                  </SMTPAuthenticate>
                  <From></From>
                  <EmbeddedRenderFormats>
                     <RenderingExtension>MHTML</RenderingExtension>
                  </EmbeddedRenderFormats>
                  <PrivilegedUserRenderFormats>
                  </PrivilegedUserRenderFormats>
                  <ExcludedRenderFormats>
                     <RenderingExtension>HTMLOWC</RenderingExtension>
                     <RenderingExtension>NULL</RenderingExtension>
                     <RenderingExtension>RGDI</RenderingExtension>
                  </ExcludedRenderFormats>
                  <SendEmailToUserAlias>True</SendEmailToUserAlias>
                  <DefaultHostName>
                  </DefaultHostName>
                  <PermittedHosts>
                  </PermittedHosts>
               </RSEmailDPConfiguration>
            </Configuration>
         </Extension>
         <Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension">
            <MaxRetries>3</MaxRetries>
            <SecondsBeforeRetry>900</SecondsBeforeRetry>
            <Configuration>
               <DocumentLibraryConfiguration>
                  <ExcludedRenderFormats>
                     <RenderingExtension>HTMLOWC</RenderingExtension>
                     <RenderingExtension>NULL</RenderingExtension>
                     <RenderingExtension>RGDI</RenderingExtension>
                  </ExcludedRenderFormats>
               </DocumentLibraryConfiguration>
            </Configuration>
         </Extension>
         <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
      </Delivery>
      <DeliveryUI>
         <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
            <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
            <Configuration>
               <RSEmailDPConfiguration>
                  <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
               </RSEmailDPConfiguration>
            </Configuration>
         </Extension>
         <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
      </DeliveryUI>
      <Render>
         <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/>
         <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
         <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>
         <Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>
         <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/>
         <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>
         <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
         <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
         <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
         <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/>
         <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/>
         <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>
      </Render>
      <Data>
         <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
         <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.DataExtensions.SqlAzureConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
         <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
         <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
         <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/>
         <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
         <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
         <Extension Name="Devart.Data.PostgreSql" Type="Devart.Data.PostgreSql.ReportingServices.PostgreSqlConnectionWrapper, Devart.Data.PostgreSql.ReportingServices, Version=4.95.152, Culture=neutral, PublicKeyToken=09af7300eec23701" />
         <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/>
         <Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPListConnection,Microsoft.ReportingServices.DataExtensions"/>
         <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>
         <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>
         <Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
      </Data>
      <SemanticQuery>
         <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
               <EnableMathOpCasting>False</EnableMathOpCasting>
            </Configuration>
         </Extension>
         <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
               <EnableMathOpCasting>False</EnableMathOpCasting>
            </Configuration>
         </Extension>
         <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQLADW.MSSqlAdwSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
               <EnableMathOpCasting>False</EnableMathOpCasting>
            </Configuration>
         </Extension>
         <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
               <EnableMathOpCasting>True</EnableMathOpCasting>
               <DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters>
               <EnableUnistr>False</EnableUnistr>
               <DisableTSTruncation>False</DisableTSTruncation>
            </Configuration>
         </Extension>
         <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
               <EnableMathOpCasting>True</EnableMathOpCasting>
               <ReplaceFunctionName>oREPLACE</ReplaceFunctionName>
            </Configuration>
         </Extension>
         <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling"/>
      </SemanticQuery>
      <ModelGeneration>
         <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
         <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
         <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
         <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
         <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling"/>
      </ModelGeneration>
      <Security>
         <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/>
      </Security>
      <Authentication>
         <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/>
      </Authentication>
      <EventProcessing>
         <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
            <Event>
               <Type>ReportHistorySnapshotCreated</Type>
            </Event>
         </Extension>
         <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
            <Event>
               <Type>TimedSubscription</Type>
            </Event>
         </Extension>
         <Extension Name="Cache Refresh Plan Extension" Type="Microsoft.ReportingServices.Library.CacheRefreshPlanHandler,ReportingServicesLibrary">
            <Event>
               <Type>RefreshCache</Type>
            </Event>
         </Extension>
         <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
            <Event>
               <Type>SnapshotUpdated</Type>
            </Event>
         </Extension>
      </EventProcessing>
   </Extensions>
   <MapTileServerConfiguration>
      <MaxConnections>2</MaxConnections>
      <Timeout>10</Timeout>
      <AppID>(Default)</AppID>
      <CacheLevel>Default</CacheLevel>
   </MapTileServerConfiguration>
</Configuration> 
.....
and rssrvpolicy.config looks like:
.....

Code: Select all

<configuration>
    <mscorlib>
        <security>
            <policy>
                <PolicyLevel version="1">
                    <SecurityClasses>
                        <SecurityClass Name="AllMembershipCondition" Description="System.Security.Policy.AllMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="AspNetHostingPermission" Description="System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="DnsPermission" Description="System.Net.DnsPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="EnvironmentPermission" Description="System.Security.Permissions.EnvironmentPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FileIOPermission" Description="System.Security.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FirstMatchCodeGroup" Description="System.Security.Policy.FirstMatchCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="IsolatedStorageFilePermission" Description="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="NamedPermissionSet" Description="System.Security.NamedPermissionSet"/>
                        <SecurityClass Name="PrintingPermission" Description="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
                        <SecurityClass Name="ReflectionPermission" Description="System.Security.Permissions.ReflectionPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="RegistryPermission" Description="System.Security.Permissions.RegistryPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SecurityPermission" Description="System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SocketPermission" Description="System.Net.SocketPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="StrongNameMembershipCondition" Description="System.Security.Policy.StrongNameMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UnionCodeGroup" Description="System.Security.Policy.UnionCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UrlMembershipCondition" Description="System.Security.Policy.UrlMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="WebPermission" Description="System.Net.WebPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="ZoneMembershipCondition" Description="System.Security.Policy.ZoneMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                    </SecurityClasses>
                    <NamedPermissionSets>
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Unrestricted="true"
                                Name="FullTrust"
                                Description="Allows full access to all resources"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Nothing"
                                Description="Denies all resources, including the right to execute"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Execution">
                            <IPermission
                                    class="SecurityPermission"
                                    version="1"
                                    Flags="Execution"
                            />
                        </PermissionSet>
                    </NamedPermissionSets>
               <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Devart.Data.PostgreSql" Description="Code group for Devart.Data.PostgreSql data processing extension">
                  <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin\Devart.Data.PostgreSql.ReportingServices.dll" />
               </CodeGroup>
                    <CodeGroup
                            class="FirstMatchCodeGroup"
                            version="1"
                            PermissionSetName="Nothing">
                        <IMembershipCondition
                                class="AllMembershipCondition"
                                version="1"
                        />
                        <CodeGroup
                                class="UnionCodeGroup"
                                version="1"
                                PermissionSetName="Execution"
                                Name="Report_Expressions_Default_Permissions"
                                Description="This code group grants default permissions for code in report expressions and Code element. ">
                            <IMembershipCondition
                                    class="StrongNameMembershipCondition"
                                    version="1"
                                    PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100512C8E872E28569E733BCB123794DAB55111A0570B3B3D4DE3794153DEA5EFB7C3FEA9F2D8236CFF320C4FD0EAD5F677880BF6C181F296C751C5F6E65B04D3834C02F792FEE0FE452915D44AFE74A0C27E0D8E4B8D04EC52A8E281E01FF47E7D694E6C7275A09AFCBFD8CC82705A06B20FD6EF61EBBA6873E29C8C0F2CAEDDA2"
                            />
                        </CodeGroup>
                        <CodeGroup
                                class="FirstMatchCodeGroup"
                                version="1"
                                PermissionSetName="Execution"
                                Description="This code group grants MyComputer code Execution permission. ">
                           <IMembershipCondition
                                    class="ZoneMembershipCondition"
                                    version="1"
                                    Zone="MyComputer" />
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Microsoft_Strong_Name"
                                    Description="This code group grants code signed with the Microsoft strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010007D1FA57C4AED9F0A32E84AA0FAEFD0DE9E8FD6AEC8F87FB03766C834C99921EB23BE79AD9D5DCC1DD9AD236132102900B723CF980957FC4E177108FC607774F29E8320E92EA05ECE4E821C0A5EFE8F1645C4C0C93C1AB99285D622CAA652C1DFAD63D745D6F2DE5F17E5EAF0FC4963D261C8A12436518206DC093344D5AD293"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Ecma_Strong_Name"
                                    Description="This code group grants code signed with the ECMA strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="00000000000000000400000000000000"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Report_Server_Strong_Name"
                                    Description="This code group grants Report Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100272736AD6E5F9586BAC2D531EABC3ACC666C2F8EC879FA94F8F7B0327D2FF2ED523448F83C3D5C5DD2DFC7BC99C5286B2C125117BF5CBE242B9D41750732B2BDFFE649C6EFB8E5526D526FDD130095ECDB7BF210809C6CDAD8824FAA9AC0310AC3CBA2AA0523567B2DFA7FE250B30FACBD62D4EC99B94AC47C7D3B28F1F6E4C8"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust">
                                <IMembershipCondition
                                        class="UrlMembershipCondition"
                                        version="1"
                                        Url="$CodeGen$/*"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="SharePoint_Server_Strong_Name"
                                    Description="This code group grants SharePoint Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100AFD4A0E7724151D5DD52CB23A30DED7C0091CC01CFE94B2BCD85B3F4EEE3C4D8F6417BFF763763A996D6B2DFC1E7C29BCFB8299779DF8785CDE2C168CEEE480E570725F2468E782A9C2401302CF6DC17E119118ED2011937BAE9698357AD21E8B6DFB40475D16E87EB03C744A5D32899A0DBC596A6B2CFA1E509BE5FBD09FACF"
                                />
                            </CodeGroup>
                        </CodeGroup>
                    </CodeGroup> 
                </PolicyLevel>
            </policy>
        </security>
    </mscorlib>
</configuration> 
.....

I've restarted the SQL Server Reporting Services service, and am unable to find the devart provider in either Report Builder 3.0 or the Report Model project in the BI studio.

Could you please help?

Scott Herbert
Posts: 3
Joined: Tue 31 Aug 2010 05:25
Location: Canberra, Australia

Post by Scott Herbert » Tue 31 Aug 2010 06:44

Just following up on my above post: some of the text appears clipped off, however I think that's just a display issue on this site; the text is all there if you copy and paste out to notepad or the like.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 02 Sep 2010 15:09

Unfortunately, we don't have technical possibility to integrate into the Report Model projects.
You can see the full list of supported Report Model providers here:
http://msdn.microsoft.com/en-us/library ... L.90).aspx

Post Reply