Solved

Deploying a wcf application

Posted on 2014-11-14
3
94 Views
Last Modified: 2014-11-25
Hi. I have a WCF service published and this is my connectionstring  to the database.
<add name="DBEntities" connectionString="metadata=res://*/ServContexto.csdl|res://*/ServContexto.ssdl|res://*/ServContexto.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=10.1.1.71;initial catalog=DB;persist security info=True;user id=usr_xxx;password=YYYYYYYYY;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

another connectionstring "Provider=SQLOLEDB;SERVER=10.1.1.71;DATABASE=producao;UID=homologacao;PWD=ZZZZZZZZZ;"

using the first connection with my wcf service, I got a error 500. and the second, a legacy application works fine.

basically the difference is the provider. how my publish could upload the sqlclient provider?

I have a test method that does not use the database and it works ok. only the methods that use the database fail.

thx in advance.
0
Comment
Question by:Deraldo Silva
  • 2
3 Comments
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 40443416
Try turning on the display of custom errors so that you can see what the underlying issue is. Modify your web.config with the information found here:

http://msdn.microsoft.com/en-us/library/h0hfz6fc(v=vs.85).aspx

Spceficially, setting customErrors to off should allow you to see the exception detail. You'll need to turn on debug mode as well:

http://msdn.microsoft.com/en-us/library/e8z01xdh.aspx

Be sure to remove these added settings before you go to production!
0
 

Accepted Solution

by:
Deraldo Silva earned 0 total points
ID: 40456827
Hi.
The problem occurred because the sql server native client was not installed.
It comes with sql server as in http://msdn.microsoft.com/pt-br/library/ms131321(v=sql.110).aspx
and from here https://www.connectionstrings.com/download-sql-server-native-client/

thx for your attention
0
 

Author Closing Comment

by:Deraldo Silva
ID: 40464129
After install the missing component, the deploy works fine.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question