Re: How to ensure that client connects to server throug the internet instead of LAN
From: Oscar (oku_at_xs4all.nl)
Date: 03/01/04
- Next message: Andrew John: "Re: Change user"
- Previous message: Utada P.W. SIU: "Change user"
- In reply to: James Hokes: "Re: How to ensure that client connects to server throug the internet instead of LAN"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 1 Mar 2004 02:56:17 +0100
Hi James,
For testing purposes, the tests are performed from clients within the same
LAN where the database servers resides.
The LAN is connected to the internet by a router and a DSL modem. The test
environment only has one line and DSL modem to connect to the internet and
that's why I can't perform tests with separate lines through separate
modems. I just need to have the router sent the request to the internet
server instead of directly to the same server by means of the LAN.
I think the problem is that the router probably sees that the IP-address is
available within the LAN and therefore doesn't connect the client to the WAN
but directly through the LAN.
Can you please provide an example how to put an Alias entry in the client
config for SQL Server to
use the internet IP of the machine when referencing it by name
regards,
Oscar
"James Hokes" <noemail@noway.com> schreef in bericht
news:e15XE1x$DHA.624@TK2MSFTNGP11.phx.gbl...
> Oscar,
>
> Are you saying that these users are not using the LAN to access the
> internet?
>
> What is it, a modem connection or something?
>
> You could always put an Alias entry in the client config for SQL Server to
> use the internet IP of the machine when referencing it by name.
>
> James Hokes
>
> "Oscar" <oku@xs4all.nl> wrote in message
> news:40425181$0$122$e4fe514c@dreader8.news.xs4all.nl...
> > 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,
> > Oscar
> >
> >
>
>
- Next message: Andrew John: "Re: Change user"
- Previous message: Utada P.W. SIU: "Change user"
- In reply to: James Hokes: "Re: How to ensure that client connects to server throug the internet instead of LAN"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
