Accessing SQL Server 2000 from Windows Vista is very slow

[Claudio]

I have a Visual C++ application using CRecordset to connect with Sql Server
2000 on Windows 2000 Server on a Local Network,
the ODBC connection string is:
ODBC;DRIVER={SQL
Server};SERVER=servername;DATABASE=dbname;Trusted_Connection=Yes

Running the application on the computer with Windows Vista Home, the tables
opening
on Sql Server is very slow,
whereas running the same application on Windows 2000 the open is very fast.

Someone can help me to solve this issue?
I already tried to:
- disable Windows Defender
- disable Windows Firewall
- activate and use the Administrator login
- disable the IPv6 protocl
- disable autotuning
there a re no antivirus software on computer with Windows Vista
.... but resultless :-((

Thanks for any help
Claudio

 

[Andrew McLaren]

Running the application on the computer with Windows Vista Home, the
tables
opening
on Sql Server is very slow,
whereas running the same application on Windows 2000 the open is very
fast.

Hi Claudio

For this kind of problem, I would install Network Monitor onto the Vista
machine. Then get a network trace of the app opening the SQL Table.

Examine the trace to see where the delays occur. Is it is session
establishment? Authentication? Slow responses from server? etc.

This in turn, will lead you to the solution.

http://www.microsoft.com/downloads/...f4d8-4213-8d17-2f6dde7d7aac&displaylang=en&tm

Hope it helps,

 

[Rick Lipkin]

Claudio

Use sqloledb ( ado ) instead of odbc .. lots of info on MSDN for Visual
Studio and C++ apps.

RIck Lipkin