DB Link from MSSQL 2005 to MSSQL 2008

[rob11nj]

I have a SQL Server 2005 DB (8.0.2055) and need to connect to another DB on a SQL 2008 (9.0.4207) server to pull some data. I've tried creating a new Linked Server entry selecting SQL Server as the server type and tried querying the data by using something like

SELECT * FROM OPENQUERY(linkname, 'SELECT * FROM dbname..tablename')

but I receive the following error:

[OLE/DB provider returned message: Deferred prepare could not be completed.]

I'm guessing I need to do something special to be able to connect to the 2008 DB but am not really sure what that is. Any help would be greatly appreciated.

 

[rob11nj]

Oops I messed up the version of the SQL2008.. I am not able to connect to it from my 2005 Management Studio so I don't know the exact version. The version I wrote down for it was for the wrong db server, please ignore that.

Thanks.