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

avatar image

11 1 1 3

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

avatar image

592 4 6 11

(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

avatar image

Felipe Ferreira
306 1 2 3

(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



Answers and Comments

SQL Server Central

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



asked: Oct 27, 2009 at 01:46 PM

Seen: 2262 times

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

Copyright 2018 Redgate Software. Privacy Policy