Could anyone help with me newcomer questions ?
I have a web server which is running SQL server 7.0, and is hosted and
manged by a third pary company. I wish to pull (subscribe) data from this
into our intranet server, also running MSSQL 7.
Every time I try to set this up using the New>Pull Subscription, the remote
(web) server cannot be found. I am entering the IP address in the Server
dialogue, and the login is correct, but just get back the message "Specified
SQL Server not found. ConnectionOpen(CreateFile())"
Any suggestions most appreciated.