dial-up access to database

I am working with VB6 and SQL Server 7. My applicaion needs to connect to the local server (connected via cabling) and also to a remote SQL Server(7) from time to time to access data. How can I access the remote server using a telephone line ?. Please Help.

Assuming that remote SQL Server is running on an NT4/2000 Server,
someone will have to configure it for remote dialup access (rasman on
NT4.) Every workstation that your app is installed on will have to have
Dialup Networking set up for remote windows networking. Your app
could possibly be changed to do the dialup itself, but in a NT type network,
I an not sure how feasible that is. Other possibilites are various VPN
setups over the internet, so that that remote server can seem to be on
the same network, without having to dial directly in to it.

I think therefore I am... sometimes right. images/icons/wink.gif