Modem connection

aloha...

i'm here to ask about something that might be so easy to other(s), but I've got no clue, since i'm new in this stuff.

I've got a server on my LAN, which has SQL Server 2K installed in it. What I'm trying to do is (my question), is it possible to access the SQL from my home (using modem) ? If so, how to do it in VB ? The flow will be :

Input Module (VB) at home => Modem (dial up) => SQL Server 2K

FYI : the server isn't at my home, but at my office.
Is it possible to do that ? if so, how ?
And, if don't mind, can someone post a simple example (in VB) on how to do this, so I will have a better view on this stuff.

:)

Regards,
[-w-]

If you are on the same network as the server - whether it is via a LAN, WAN, dial-up, stretched piece of string or whatever you should be able to access the SQL Server by it's network name, or failing that, it's IP address.

Eg.

cn.Open "Provider=SQLOLEDB;Server=MYSERVER......"

or

cn.Open "Provider=SQLOLEDB;Server=a.b.c.d ... (IP address)

well...

not at the same network. My home has no network. only a modem to dial. .....
Network (LAN) only at my office. From home, I use a dial up modem to connect to internet. And is it possible to access the server (SQL Server) at my office ?

if we're on the same network (LAN, WAN, etc), I know I can use the command. :) Thx anyway.....


Regards,
[-w-]

You need to be able to dial-up to your work network in the same way as you dial-up to your ISP for internet connection.
If there are people working at home or 'in the field' at your office then you no doubt already have this facility.
Speak to your Network Support guys about a dial-up to the network.

hmm... correct me if I misunderstood....
Do you mean that, if I dial my modem to my office, than, everything is possible ? is it mean that if I dial my modem to my office then, I am at the same network ? though I have no network at my home....

if so... after I dial to my office, get connected, then, from VB, I just type the local IP address (at open connection) of my server (where SQL Server located) ?

Regards,
[-w-]

Your Network Support people need to provide you with a phone number, username and password for you to be able to connect to the office network from your home phone.

If they do this, once you dial up and connect you are effectively on the same network as the server so you should be able to access it in the normal way.

btw,
if i connect through a dial up modem, .... let's say I've connected to my office, isn't the IP address is different from my office LAN subnet ?
can i just type the local IP address of my server when I open an ADO connection ?