Click here to Skip to main content
14,487,309 members
Rate this:
Please Sign up or sign in to vote.
See more:
Got Failure in Deployment of WCF in IIS 7. My procedure is below:
1) Create a WCF project and can run it successfully (results displayed in http://localhost:48677/Service1.svc/GetDataSet1/tblName[^].
2) In IIS Manager, add a web site (Physical Path to the project, Port: 48766, Binding Type: http, IP address: All unassigned).
As the service is in start-status, I used the same IP address on the browser, but got Request Error:
The server encountered an error processing the request. 

But, the service's wsdl is viewable at http://localhost:48677/Service1.svc?wsdl[^].
How to solve this problem? I mean that I can run the service like that I did by running the debugging. Thanks.
Updated 12-Nov-13 7:13am
[no name] 12-Nov-13 13:58pm
Referring the article:, I set includeexceptiondetailinfaults="true",
<behavior name="myServiceBehavior">
<servicedebug includeexceptiondetailinfaults="true">

But got new error:
The server encountered an error processing the request. The exception message is 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'. See server logs for more details. The exception stack trace is:

at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at WcfService_Data.Service1.GetDataSet1(String tableName) in C:\Yu\GIS\DotNet\WcfService_Data\WcfService_Data\Service1.svc.cs:line 52 at SyncInvokeGetDataSet1(Object , Object[] , Object[] ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
[no name] 12-Nov-13 14:39pm
Revised the code to use OracleClient instead of OleDB. Still got the problem: This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.' but this time if for OracleClient.
[no name] 12-Nov-13 15:04pm
I checked the Oracle's SQL Developer that was installed my machine. It is in Version Oracle 11g Release 2, 64 bit. But the error message shows 'This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed'. What does it mean? Wish someone can interpret it. Thanks.
bluesathish 13-Nov-13 2:10am
Try this, In your IIS application pool -> Goto advanced property -> set enable 32 bit application to True. Defaultly its set to false. Try this and revert.
[no name] 13-Nov-13 7:19am
I also tried this. Unfortuantely, in my IIS 7 Advanced Settings for a service, there is no option for the Set Enable 32 bit application.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100