SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Reporting Server - Data Provider for SAP
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Shane2077
Starting Member

Australia
4 Posts

Posted - 12/02/2012 :  17:32:39  Show Profile  Reply with Quote
Hi all,

We have installed the Data Provider for SAP adapter (BizTalk) on our Reporting Server. The extension name "Data Provider for SAP" exists in rsreportserver.config. However when trying to create a dataset in Report Builder on a named instance on the Report Server the error "The selected data extension Data Provider for SAP is not installed or cannot be loaded". The Biztalk adapter has been uninstalled and reinstalled with the same error message being displayed.

If anyone could give a suggestion of where to start looking in the Report Server configuration to get this working it would be appreciated.

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 12/03/2012 :  08:56:21  Show Profile  Reply with Quote
have you tried adding the required references in report project?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

su_enm
Starting Member

1 Posts

Posted - 03/23/2013 :  03:11:07  Show Profile  Reply with Quote
hi,

could you find the solution for the error. i have the same problem :(

thanks
Go to Top of Page

Shane2077
Starting Member

Australia
4 Posts

Posted - 03/26/2013 :  17:53:21  Show Profile  Reply with Quote
Hi Su-enm,

No solution could be found. The Data Provider for SAP is installed on the Reporting Server (rsconfig), however when executing Report Builder, Report Builder runs from the client side with the config file loaded from resources of MSReportBuilder.exe. Those resources are hard coded and cannot be modified to add in the Data Provider for SAP. What I am now doing is creating SAP data sources and datasets in BIDS and deploying the datasets to the Report Server where the reports can then be built using Report Builder and then published on the Reporting Server.

Hope this helps
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000