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
Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.