Databases
StackOverflow2013
Postsdbo
POTesting for network connectivity via opening a database connection
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTesting for network connectivity via opening a database connection
    text
    copied!<p>I have a little .net 2.0 systray app (C#) that checks for network connectivity periodically. It does this by attempting to open a connection to a SQL-Server instance on another computer (and selection a row from a table). The application saves documents created by another process to a database when it finds a connection. It is going to be used in environments with potentially dicey wireless networks.</p> <p>In testing our QA team is using <code>ipconfig /Release</code> on the DB server (hosting a Sql-Server 2005 DB). What we found was that the application continued to claim it was network connected, because it kept right on successfully opening connections to SQL Server. I found the systray app's behavior erratic in my own testing using <code>ipconfig /release</code>.</p> <p>At the suggestion of our not-currently-present network guy I changed my own internal testing (app hosted on a VM, connecting to DB on my workstation) to instead turn off the VM network connection. This produces the expected behavior (the systray app can't find a network connection). The QA guys are a little leery about my suggested that they do the same, and I need to put them at ease.</p> <ol> <li><p>It was suggested to me that SQL Server was using named-pipes to accept incoming connections. If Named Pipes and TCP/IP are enabled, does this invalidate the <code>ipconfig /release</code> test?</p></li> <li><p>I don't really know much about networking. Named-pipes, according to what I have read, sounds like it is designed for use between applications on the same server. But it can be used for intranet communications?</p></li> <li><p>Is there something else going on here that I an unware of? Something about how <code>ipconfig /release</code> works </p></li> </ol>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload