View Single Post
Old 10-05-2007   #3 (permalink)
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@xxxxxx> wrote in message
news:e3bWuhzBIHA.4476@xxxxxx
Quote:

>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
>
>
>
>

My System SpecsSystem Spec