ADO.NET System.Data.SqlClient

[Guest]

I'm developing web applications using Visual Studio.NET 2003 Version 7.1.3088
on two laptop configurations. One is Windows 2000 Professional, other is
Windows XP SP2. Microsoft.NET Framework 1.1 Version 1.1.4322 SP1 (on XP
Laptop), Microsoft.NET Framework 1.1 Version 1.1.4322 (on 2K Laptop). I have
SQL Server 2000 - Version 8.00.0384 - SP4 installed on standalong machine.

I've used VB.NET 2003 for over 1.5 yrs - no problems on 2K platform. I have
web application connecting flawlessly to SQL server using SqlClient namespace.
I have "headaches" while migrating same web application on XP platform.
Continually getting message "System.Data.SqlClient.SqlException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding". Basically SQL Server 2000 - is fully
operation for all apps, includes web app on 2000 Professional development
machine. Just can't get SQL connects to database on XP Sp2 platform. I feel
differences in OS are causes - different DLL's, possible issue with MDAC -
TDS stream issue. I've submitted 3 postings to other newsgroups. Other
disagree with MDAC issue & OS issue.

I guess my questions are then - What is causing this to NOT work on SP2 of
XP platform - same code - etc... Just 98% of time WON'T connect - once in
blue-moon connection passes with XP Sp2. Again, no problems with 2000 OS
platform.

Please advise!

 

[Andrew Robinson]

Do both boxes have the same version of MDAC? Check your versions or download
the latest.

http://msdn.microsoft.com/data/mdac/downloads/default.aspx

 

[Guest]

This is resolved - see dotnet.framework.aspnet 05/24/2004 "Any Help here???"
title.

Allset -------------------

 

[Guest]

Thanks Andrew - Allset here.

I had issue with SQL Server itself - wasn't obvious since all was well when
running on 2000 OS platform. But for some reason - XP Sp2 - showed there was
issue. For now, I have workaround - using alternate IP port - and also have
fix to resolve connection issue problem to SQL that NOW is made apparent by
XP. I pinged to find out more about server itself - and issues are more
inherent with our setup. I also have fix.

Thanks for responding - see my prior post - it summarizes
dotnet.framework.ASPNET area where I got idea for solution.

Also - I did download yesterday Product Support Reporting Tools - for MDAC -
I actually LIKE THIS TOOL ALOT from Microsoft. I assume your web link also
applies here - and I'll check out shortly.

Finally - I tend to be negative to MS with I have problems - but in general
- I do like your OS - but someday I'll submit suggestions concerning new OS
releases.