Keep it simple as possible first.

NT 4 Server
SQL Server (6.5 or 7)
DSN connection
TCP/IP network

Sounds like ASP web conections would be nice and easy too!