|
Home > Archive > MS SQL Server > March 2006 > RE: Access to SQL 2000 Server database over dialup much slower on
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RE: Access to SQL 2000 Server database over dialup much slower on
|
|
| Tony Saucedo 2006-03-14, 11:23 am |
| I did not notice the connection speed. I'll check it and the MDAC version. I
would have thought that XP Pro would have had a better version of MDAC, hmmm.
Ok.
If the connection and transfer works better with W2K, does that indicate
that Server side cursor is being used or not. Where can I check this setting?
Do you know if XP handles client-side cursor differently then W2K?
I'll have to try the profiler later since the server is at a remote site.
Thanks.
Tony
"John Bell" wrote:
[color=darkred]
> Hi
>
> Have you checked the connection speeds to see if they are different?
>
> If you download the MDAC component checker you can verify which versions of
> MDAC are being used.
>
> Also make sure that things like server side cursors are being used.
>
> You may want to confirm using profiler that the queries are not different
> and they take the same length of time to complete. This may also confirm if
> you are setting the options differently.
>
> John
> "Tony Saucedo" wrote:
>
| |
| John Bell 2006-03-14, 11:23 am |
| Hi Tony
The difference could be in what options are set, although I don't remember
any defaults being different unless on your Windows 2000 system you are
running a very old version. An application change would be the most likely to
change to location of the cursors. I assume you have not changed the database
between these two events?
Also have you checked ODBC tracing is not on?
Is the connection speed any different and are you using the correct drivers?
John
"Tony Saucedo" wrote:
[color=darkred]
> I did not notice the connection speed. I'll check it and the MDAC version. I
> would have thought that XP Pro would have had a better version of MDAC, hmmm.
> Ok.
>
> If the connection and transfer works better with W2K, does that indicate
> that Server side cursor is being used or not. Where can I check this setting?
>
> Do you know if XP handles client-side cursor differently then W2K?
>
> I'll have to try the profiler later since the server is at a remote site.
> Thanks.
>
> Tony
>
> "John Bell" wrote:
>
|
|
|
|
|