>My APP connect to a Sql2k server by tcp/ip, the Sql2k Server conect to internet by dialup.
>
>The App can connect to it with its IP address where I use Sql 7.0. But it doesn't work with Sql2k.
>
>After the Sql2k Server connect to Internet, I have to stop and restart it again to let my APP got the connection.
>
>What's the reason, how can I solve it ?
Have you tried using an alias to access the remote Sql2k server?
It's done with the SQL Server Client Network Utility, which allows adding logical aliases mapping to the physical IP addresses.
Hope this helps- bye
Jose