Internet Information Server (IIS) on Shared Hosting
Internet Information Server (IIS) on Shared Hosting
created. These are in the repository folder.
Locate the folder where the SQL Server Compact private deployment libraries is located (C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private) by default).
Copy the contents of this folder into the bin folder of your Report Web Service in your web site; you should replace one file.
Modify your web.config file and add the following lines anywhere inside the <configuration></configuration> tags to register SQL Server Compact:
<system.data> <DbProviderFactories> <remove invariant=”System.Data.SqlServerCe.4.0″/> <add name=”Microsoft SQL Server Compact Data Provider 4.0″ invariant=”System.Data.SqlServerCe.4.0″ description=”.NET Framework Data Provider for Microsoft SQL Server Compact” Type=”System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91″/> </DbProviderFactories> </system.data> <runtime> <assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″> <dependentAssembly> <assemblyIdentity name=”System.Data.SqlServerCe” publicKeyToken=”89845dcd8080cc91″ culture=”neutral”/> <bindingRedirect oldVersion=”0.0.0.0-65535.65535.65535.65535″ newVersion=”4.0.0.1″/> </dependentAssembly> </assemblyBinding> </runtime>
Once you have done so, you can test your configuration by going to the address of the Web site you used in the configuration. For example, if the web site is configured to use port 800, and you use the Alias “Reports”, then the address of the Report Server and the Report Web Service will be http://MySharedServer.com:800/Reports.
If the configuration is correct and you can see the Report Web Service interface and be able to log in using your credentials, then you can use this Report Server in XLReport by connecting to it.
We use cookies
We use cookies and other tracking technologies to improve your browsing experience on our website, to show you personalized content and to analyze our website traffic, and to understand where our visitors are coming from. By browsing our website, you consent to our use of cookies and other tracking technologies.