The underlying provider failed on Open
        Posted  
        
            by senzacionale
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by senzacionale
        
        
        
        Published on 2010-03-19T04:36:11Z
        Indexed on 
            2010/03/19
            4:41 UTC
        
        
        Read the original article
        Hit count: 803
        
c#
I was using .mdf for connect to DB and entityClient. Now i want to change connection string that trehe will be no .mdf
Is this conectionstring correct
<connectionStrings>
<!--<add name="conString" connectionString="metadata=res://*/conString.csdl|res://*/conString.ssdl|res://*/conString.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQL2008;AttachDbFilename=|DataDirectory|\NData.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />-->
<add name="conString" connectionString="metadata=res://*/conString.csdl|res://*/conString.ssdl|res://*/conString.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQL2008;Initial Catalog=NData;Integrated Security=True;Connect Timeout=30;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />
becouse i always get error !The underlying provider failed on Open!
© Stack Overflow or respective owner