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.
Best Answer
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...
why can't you just update the native client components to sql 2005?
