- Where Developers Learn, Share, & Build Careers


I am using configurationmanager.appsetting and I'm getting an error in Cn.Open line

The web form code is as follows: 

  Public partial category admin_CheckDocuments: System.Web.UI.Page {SqlConnection cn = New SqlConnection (Configuration Manager. AppSettings ["con" ]); String sql; String str; Secure Zero Page_load (Object Sender, EventEurge E) {cn.Open (); Str = Request.QueryString ["taxid"]; If (! IsPostBack) {filldata (); }}   
  web.config :  
   & Lt; / AppSettings & gt;   
 error  
 
  A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the example name is correct and SQL Server is configured to allow remote connection. (Provider: SQL Network Interface, Error: 26 - Error specifying server / instance)     
 
 
 Due to throwing this problem wrong server name, disabled remote connection and firewall may be blocked.  
 Can you follow the steps given below to solve this problem?  
  Check a server on which SQL Server is running, it can be accessible. You can use the ping command to check it. For example, the ping command can be blocked by the ping **  or the ping   firewall, make sure that the ICMP is enabled in the firewall **  
  Select the appropriate protocol   
  · Configure the Windows Firewall accordingly, depending on the protocol used. For detailed information about how to configure Windows Firewall to allow SQL Server, please   
  One. Enable SQL Server Browser Services  < / P> 
 Check to enable SQL Server Browser Services if both of the following are true:  
  1.SQL server is not listening to the default 1433 port or does not use the default pipe name Does. \ Pipe \ sql \ query;   
  2. The related TCP port or pipe name is not specified in the connection string (eg Srv1 \ SQL2008, 1500).   
 If you have enabled SQL Server Browser Services, you still need to open the UDP 1434 port which is used by browser services in Windows Firewall.  
 I know that it has been resolved   
है

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more