General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only