|
Microsoft Reporting Services 2005 + Oracle Database
|
|||
---|---|---|---|
#18+
Приветствую друзья ! Прошу Вашего совета. В компании имеется БД на Oracle. Необходимо внедрить MS Reporting Services. Для этого выделил сервер на Windows 2008 R2 x64 и для пробы установил SQL Server 2005 Express Edition with Advanced Services SP2. Проверил веб интерфейс доступен, но при попытке создания через веб интерфейс "источника данных" в строке "тип соединения" есть только Microsoft SQL Server. Поставил Oracle client, настроил ODBC соединение для Oracle. Соединение с базой есть. Вопрос-как создать "тип соединения" для Oracle? Спасибо. ... |
|||
:
Нравится:
Не нравится:
|
|||
06.02.2013, 18:58 |
|
Microsoft Reporting Services 2005 + Oracle Database
|
|||
---|---|---|---|
#18+
возможно это ограничение Express Edition поищите rsreportserver.config и посмотрите есть ли там в узле <Data> записть с регистрацией oracle data provider <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> ... |
|||
:
Нравится:
Не нравится:
|
|||
06.02.2013, 23:42 |
|
Microsoft Reporting Services 2005 + Oracle Database
|
|||
---|---|---|---|
#18+
LevSвозможно это ограничение Express Edition поищите rsreportserver.config и посмотрите есть ли там в узле <Data> записть с регистрацией oracle data provider <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> У меня тоже мысли что все из за Express Edition. Посмотрел по вашему совету rsreportserver.config, строчка про Oracle там есть.. ... |
|||
:
Нравится:
Не нравится:
|
|||
07.02.2013, 10:00 |
|
Microsoft Reporting Services 2005 + Oracle Database
|
|||
---|---|---|---|
#18+
Meauuw, В экспресс-редакции Reporting Services источник данных Oracle не поддерживается: Analysis Services, Oracle, XML, SAP, SQL Server Integration Services (SSIS), OLE DB, and ODBC data sources are not supported. ... |
|||
:
Нравится:
Не нравится:
|
|||
07.02.2013, 12:34 |
|
Microsoft Reporting Services 2005 + Oracle Database
|
|||
---|---|---|---|
#18+
Действительно все дело в Express Edition. Друзья, подскажите как решить проблему(скрин с ошибкой см. во вложении) ... |
|||
:
Нравится:
Не нравится:
|
|||
07.02.2013, 17:37 |
|
Microsoft Reporting Services 2005 + Oracle Database
|
|||
---|---|---|---|
#18+
разрешить named pipes и tcp протоколы для инстанса sql server (в sql server configuration manager) ... |
|||
:
Нравится:
Не нравится:
|
|||
07.02.2013, 23:58 |
|
Microsoft Reporting Services 2005 + Oracle Database
|
|||
---|---|---|---|
#18+
LevS, Спасибо за ответ! На самом деле проблема была всего лишь в неверной строке коннекта к sql серверу. Правда тут же возник еще один вопрос. Настроил коннект к базе Oracle, всё замечательно, но теперь почему то не работает IIS. Когда просто в адресной строке ввожу имя сервера то отображается картинка IIS 7, а вот когда ввожу %имя сервера%/Report или /ReportServer, то выдаётся ошибка HTTP 500 Internal Server Error. Посмотрел в IIS виртуальные каталоги не создались сами во время установки, хотя папки в директории Reporting Services есть. Ума не приложу почему перестал работать сайт, т.к. вчера все работало, пока настроил коннект к базе перестал работать сайт. ... |
|||
:
Нравится:
Не нравится:
|
|||
08.02.2013, 21:16 |
|
Microsoft Reporting Services 2005 + Oracle Database
|
|||
---|---|---|---|
#18+
в логах вот что пишет... appdomainmanager!DefaultDomain!c!02/08/2013-12:11:54:: i INFO: Appdomain:3 ReportServer_SQLSERVER_REP_0-1-130048279146177234 started. appdomainmanager!DefaultDomain!c!02/08/2013-12:11:54:: e ERROR: AppDomain ReportServer_SQLSERVER_REP_0 failed to start. Error: Could not load file or assembly 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 174) library!DefaultDomain!c!02/08/2013-12:11:54:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to create HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_SQLSERVER_REP_0. ---> System.Web.HttpException: Could not load file or assembly 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 174) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 174) ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. File name: 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. --- End of inner exception stack trace --- at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase) at System.Web.Configuration.HealthMonitoringSectionHelper.BasicSanityCheck() at System.Web.Configuration.HealthMonitoringSectionHelper..ctor() at System.Web.Configuration.HealthMonitoringSectionHelper.GetHelper() at System.Web.Management.HealthMonitoringManager..ctor() at System.Web.Management.HealthMonitoringManager.Manager() at System.Web.Management.HealthMonitoringManager.get_Enabled() at System.Web.Management.WebBaseEvent.RaiseSystemEventInternal(String message, Object source, Int32 eventCode, Int32 eventDetailCode, Exception exception, String nameToAuthenticate) at System.Web.Compilation.AssemblyBuilder.Compile() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) at System.Web.Compilation.BuildManager.CompileGlobalAsax() at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() --- End of inner exception stack trace --- at System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironmentAndReportErrors(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.GetAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateObjectInternal(String appId, Type type, IApplicationHost appHost, Boolean failIfExists, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.ApplicationManager.CreateObject(String appId, Type type, String virtualPath, String physicalPath, Boolean failIfExists, Boolean throwOnError) at ReportingServicesHttpRuntime.RsHttpRuntime.Create(RsAppDomainType type, String vdir, String pdir, Int32& domainId) --- End of inner exception stack trace ---; appdomainmanager!ReportServer_0-1!c!02/08/2013-12:11:54:: i INFO: Appdomain:3 ReportServer_SQLSERVER_REP_0-1-130048279146177234 unloading library!DefaultDomain!c!02/08/2013-12:11:54:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: Failed to create Report Server HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: An error occurred when attempting to start the application domain ReportServer within the Report Server service. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_SQLSERVER_REP_0. ---> System.Web.HttpException: Could not load file or assembly 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 174) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 174) ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. --- End of inner exception stack trace ---; rshost!rshost!c!02/08/2013-12:11:54:: e ERROR: Failed to create HttpRuntime 80131500. rshost!rshost!c!02/08/2013-12:11:54:: e ERROR: Failed to get appdomain 80131500, pipeline=0x000000000037DA40. rshost!rshost!c!02/08/2013-12:11:54:: e ERROR: Error state. Internal abort for pipeline=0x000000000037DA40 ... appdomainmanager!DefaultDomain!dd8!02/08/2013-12:12:00:: i INFO: Appdomain:3 ReportServer_SQLSERVER_REP_0-1-130048279146177234 unregistered. rshost!rshost!dd8!02/08/2013-12:12:00:: i INFO: Application domain type ReportServer statistics: created: 1, unloaded: 1, failed: 0, timed out: 0. ... |
|||
:
Нравится:
Не нравится:
|
|||
09.02.2013, 00:14 |
|
|
start [/forum/topic.php?fid=31&msg=38144104&tid=1534125]: |
0ms |
get settings: |
11ms |
get forum list: |
14ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
31ms |
get topic data: |
11ms |
get forum data: |
3ms |
get page messages: |
44ms |
get tp. blocked users: |
1ms |
others: | 15ms |
total: | 138ms |
0 / 0 |