x
login about faq Site discussion (meta-askssc)

SQL 2005 Server with Client Connections using SQL 2000 client

Are there any known connection performance issues using the SQL 2000 client to connect to SQL 2005 server. (TCP connection)(hosting envionment)

Nevermind... just realizing what a thoughtless question it was. Just having issues in a hosting environment and searching for some direction.

more ▼

asked Oct 27 '09 at 01:46 PM in Default

RayA gravatar image

RayA
11 1 1 1

Can you clarify what you mean by SQL 2000 client?

Oct 27 '09 at 02:13 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

For some years i worked with sql2000 and sql2005 and i never experienced conectivity issues that just happed because one of their versions.

Are you experiencing any connection issue ? If yes, can you give us some details ?

There is a great article that describe some connection issues: http://blogs.msdn.com/sql_protocols/archive/2005/10/22/sql-server-2005-connectivity-issue-troubleshoot-part-i.aspx

Client connection strings also changes between versions, and can be found here: http://www.connectionstrings.com/

Let us know if this helps...

more ▼

answered Nov 04 '09 at 02:46 PM

Gustavo gravatar image

Gustavo
592 4 4 7

(comments are locked)
10|1200 characters needed characters left

why can't you just update the native client components to sql 2005?

more ▼

answered Oct 27 '09 at 04:04 PM

Felipe Ferreira gravatar image

Felipe Ferreira
306 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1835
x220
x7

asked: Oct 27 '09 at 01:46 PM

Seen: 1259 times

Last Updated: Nov 05 '09 at 05:24 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.