Hello,

I have two Win 2k Advanced Server boxes. One contains ASP pages. The other has MS SQL server on it.

The machines are connected with IP only. They are not "networked" together, no shared drives, etc.

I have been reading up on connection strings, but I can't figure out how to force a TCP/IP connection.

This is what I came up with, but it doesn't work.

<%
strConnect = "Driver={SQL Server}; Server=sql://sqlserv.example.com:1433; database=hous1; uid=floppy; pwd=32disk99"
%>

Thanks,
Scott