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.
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...
answered Nov 04 '09 at 02:46 PM
why can't you just update the native client components to sql 2005?
answered Oct 27 '09 at 04:04 PM