x

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, 2009 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, 2009 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, 2009 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, 2009 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1947
x249
x8

asked: Oct 27, 2009 at 01:46 PM

Seen: 1832 times

Last Updated: Nov 05, 2009 at 05:24 AM