How to ensure that connection is made through internet instead of WAN ?

I am programming a VB-SQL Server 2K application which connects the clients
to the database through the internet. While I am testing the application
within a LAN in which the database server as well as the client connect to
the internet through a router I can't ensure that the client connects to the
database through the internet. In case I disconnect the internet WAN
connection, the application still is able to work. So the connection must be
through the LAN I guess. However, after a short while, the application is
not able to work and displays error messages concerning that it could not
establish a connection, which I had expected right after the disconnection.
Any suggestion how I can ensure that the client within the LAN connects to
the server through the internet ?
In the connection I used the following code :
DB.Provider = "SQLOLEDB"
DB.Properties("Data Source").Value = "80.123.12.123,1433" '"DATASERVER"
regards,
OscarI do not believe there is anyway for SQL Server or MDAC to force a
connection over the internet.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||The connection routing is taken care of by the OS, so you must look at the
OS level procesing.
One thing that you might try is looking at your gateway configuration, if
you set the metric on
the WAN segment higher than the internet segment (if possible given your
network topology)
then the OS should pick the internet segment instead of the LAN.
Hope this helps.
Michael
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:cDOz0uJAEHA.3792@.cpmsftngxa06.phx.gbl...
> I do not believe there is anyway for SQL Server or MDAC to force a
> connection over the internet.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>