
Windows XP dropping connection to SQL Server 2000
I have a VB6 application that connects to SQL Server 7/2000 via OLEDB. It
works great on multiple installations of SQL 7 and one of SQL 2000 under Win
98, 2000, XP Home, and XP Pro.
But we are deploying to a big customer and their XP Pro SP1 machines aren't
working with it. After a short amount of use, an error message comes back
saying "[DBNETLIB][ConnectionWrite (send()).]General network error. Check
your network documentation."
When running on a Windows 2000 Pro machine at their location, it works fine.
We have tried NT authentication & SQL authentication, but it breaks both
ways. FWIW, the network has no DNS/WINS and the server name/IP are in the
hosts file on the clients.
Any ideas on this?
Thanks.
Daniel Wilson