September 3rd, 2011, 12:39 AM
WCF Service is showing error after implemented in IIS
Inmy project i am using Microsoft enterprise library to connet to database. It is working fine when i run the application from Visula studio directly. But this is showing error connecting to database when hosted in IIS on same machine. I have added log trace and got the following error
My web.config of service is contains as below
I tried a lot but unable to find the cause of issue. I checked the permission on the folder and Everyone has full control. WCF Service in IIS is Anonymus accesss enabled.
<configSections> <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/> <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data"/> </configSections> <dataConfiguration defaultDatabase="OracleConnection"> <providerMappings> <add databaseType="Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase, Microsoft.Practices.EnterpriseLibrary.Data" name="Oracle.DataAccess.Client"/> </providerMappings> </dataConfiguration> <connectionStrings> <add name="OracleConnection" providerName="Oracle.DataAccess.Client" connectionString="User Id=***;Password=****;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=*****)(PORT=1500)) (CONNECT_DATA=(SERVER = DEDICATED) (SERVICE_NAME =*****)));"/> <add name="SybaseConnection" connectionString="providerName=Sybase.ASEOLEDBProvider;Server=****;Port=5050;Catalog=**;User Id=***;Password=****"/> </connectionStrings>
Could anyone please help?
September 22nd, 2011, 11:02 PM
Did you get this resolved? I'm no help, I haven't used IIS since around IIS5
I've never been able to appreciate the sublime arrogance of folks who feel they were put on earth just to save other folks from themselves .." - Donald Hamilton