Re: How can I retrieve data from SQLServer with a specify network

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Thana N. (ThanaN_at_discussions.microsoft.com)
Date: 10/08/04 

Date: Fri, 8 Oct 2004 00:23:03 -0700

Sorry for my uncleared information. And yes there is no NIC issue if routing
is persisted. But my program have to run on an unstable network such as
dial-up network. So retrieving data from database from dial-up network is
unpredictable (sometimes routing table is wrong or lost). That's why I want
to know how to programming a program to route and/or check routing before
sending query to database.

Thanks for your advise.
Thana N.

"Mike Labosh" wrote:

> > The NIC is irrelevant. If the port is open (1344 or 1345) and not blocked
> > by a firewall, even if it is on a different network segment, whichever
> > nick is connected to the server will transmit/receive. In other words,
> > beyond making sure you have the port set, there's nothing more to do in
> > terms of ".Net programming".
>
> Using the correct server name in the SqlConnection helps, too. :)
>
> Dim cn1 As New SqlConnection(cnStringForServer1)
> Dim cn2 As New SqlConnection(cnStringForServer2)
>
> --
> Peace & happy computing,
>
> Mike Labosh, MCSD
>
> "It's 4:30 am. Do you know where your stack pointer is?"
>
>
>

Relevant Pages