question

RayA avatar image
RayA asked

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.

sql-server-2005performanceclient-tools
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you clarify what you mean by SQL 2000 client?
0 Likes 0 ·
Gustavo avatar image
Gustavo answered

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

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Felipe Ferreira avatar image
Felipe Ferreira answered

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

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.