HELP: Linked SQL servers issue - cannot call ServerName.Database.dbo.TableName

We recently upgraded our production SQL Server to SQL Server 64-bit
Yukon on Windows 2K3 however our development SQL server is still SQL
Server v7.
We have linked servers.
The problem is all the stored procedures fail as well as T-SQL
commands in SQL Query Analyzer because we may no longer call the
server with the 4-part naming convention (server.database.dbo.table)
while OPENQUERY still works such as:
FAILURE:
SELECT ISNULL(SUM(CAST(Reproduction_Cost1 AS money)), 0)
FROM SERVER2.DATABASE2.dbo.TABLE2
WHERE LRSN=34534534
OPENQUERY WORKS:
SELECT ISNULL(SUM(CAST(Reproduction_Cost1 AS money)), 0)
FROM
OPENQUERY(SERVER2, 'SELECT * FROM DATABASE2.dbo.TABLE2 WHERE
LRSN=34534534')
The failure message is:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not
give any information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
IUnknown::QueryInterface returned 0x80004005: The provider did not
give any information about the error.].
Any help is appreciated!On your new server make sure the remote account is the
same and the password is he same. Also check your remote
query time out length
>--Original Message--
>
>We recently upgraded our production SQL Server to SQL
Server 64-bit
>Yukon on Windows 2K3 however our development SQL server
is still SQL
>Server v7.
>We have linked servers.
>The problem is all the stored procedures fail as well as
T-SQL
>commands in SQL Query Analyzer because we may no longer
call the
>server with the 4-part naming convention
(server.database.dbo.table)
>while OPENQUERY still works such as:
>
>FAILURE:
>SELECT ISNULL(SUM(CAST(Reproduction_Cost1 AS money)), 0)
>FROM SERVER2.DATABASE2.dbo.TABLE2
>WHERE LRSN=34534534
>
>OPENQUERY WORKS:
>SELECT ISNULL(SUM(CAST(Reproduction_Cost1 AS money)), 0)
>FROM
>OPENQUERY(SERVER2, 'SELECT * FROM DATABASE2.dbo.TABLE2
WHERE
>LRSN=34534534')
>
>The failure message is:
>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'SQLOLEDB' reported an error. The
provider did not
>give any information about the error.
>OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
>IUnknown::QueryInterface returned 0x80004005: The
provider did not
>give any information about the error.].
>
>Any help is appreciated!
>.
>