Solved

Deploying a wcf application

Posted on 2014-11-14
3
92 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Copy Database Wizard 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.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

803 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