Devart Forums

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.

Thanks Alex, much appreciated.

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.

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

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

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

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,