When opening a remote view that was initially created to connect to Oracle but now set to repoint to SQL Server, the error message "object 'databasename' is not found" even though the database in the server has already been created.
We've since identified the cause of this, in Oracle, the syntax is "user.tablename", in SQL server its "dbo.tablename". We solved it by using gendbc to generate all the remote view scripts, then used notepad to replace all "user." with "dbo.".
Hope that's the caused of it...
Yau