Problems with Linked servers between sql 2000 and sql 2005

Dear all

I have created linked server object between a sql 2000 and sql 2005 database. i have the latest mdacs installed and all the services enabled on both sides.

But when i try and run a sql statement on the sql 2000 side i get this error:

[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation.

If i try and run a swl statment on the sql server 2005 side the procedure works.

Has anyone experienced the same problem?Any advice?

Thank you so much for the help.

Dan

Try also posting to the SQL Server forum at http://forums.microsoft.com/msdn/showforum.aspx?forumid=87&siteid=1

|||

Thnax for the advice.I am just about to copy this post on there.

Much apreciated