We are about to have our server (Win XP SP1 with SQL Server 2000 Personal Ed.) connect to INTERNET via DSL by having 2 IP address (1 Static IP for Internet, 1 for LAN).

Question: Can I map an ODBC DSN from a remote area (via Dial-up Internet) to our server using Static IP as server name?

Still have 45 days and counting. Getting anxious and about to be worried.

Proud To Be Pinoy

__________________
Proud To Be Pinoy

Hi,

If I understand you correctly, you can map a DSN to a remote server by name, however, you will have to put an entry into the host file on the server:

[IP Address of Server] [Server Name]
xxx.xxx.xxx.xxx WhatEverServer

I wouldn't leave that server hanging out on the Internet without a firewall though.

Good luck!
Richard

Point well taken. Thank you very much.

Proud To Be Pinoy