Windows Vista 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]

Re: Accessing SQL Server 2000 from Windows Vista is very slow

"Claudio" <claudio.orsini@ampersoftware.it> wrote ...
> 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,

--
Andrew McLaren
amclar (at) optusnet dot com dot au

 

[Rick Lipkin]

Re: Accessing SQL Server 2000 from Windows Vista is very slow

Claudio

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

RIck Lipkin

"Claudio" <claudio.orsini@ampersoftware.it> wrote in message
news:e3bWuhzBIHA.4476@TK2MSFTNGP06.phx.gbl...
>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
>
>
>
>