May 30, 2008 at 5:22 pm
Hello,
I have a SQL Server 2000 (version 8.0.2039). I am using the new MS SQL Management Studio to see Linked Servers on the server. You can get to Linked Servers by select Server Objects.
The problem is I have this Linked Servers named "HP" that connects with an Oracle DB on a HP server. "HP" is looking for a table PBWLMS.SALES_ANALYSIS.
When the owner of the table changed from DBLMS to PBWLMS, one of our reports on SSRS 2005 started generating this error message. The report uses the SALES_ANALYSIS table.
An error has occurred during report processing.
Query execution failed for data set 'CompletionStats'.
OLE DB provider 'HP' does not contain table '"DBLMS"."SALES_ANALYSIS"'. The table either does not exist or the current user does not have permissions on that table.
Is this problem with the HP Link Server or is it with SSRS 2005?
June 10, 2008 at 9:33 am
If the Oracle login id used by the linked server is fixed, it may not have access to "PBWLMS" tables. You will probably need to recreate the report since the underlying query has now changed. Just as if a table name had changed.
Otherwise on the Oracle side they could possibly create a view that is owned by '"DBLMS" called "SALES_ANALYSIS" pointed to the "PBWLMS" table.
June 12, 2008 at 3:02 am
The answer is to create a synonym within Oracle for the tables you want to view through the linked server
June 16, 2008 at 9:33 pm
If permissions are fine and synonym is not an option you may need to check schema name (to check if it's part of the table name). So, in report's query you will need to change SALES_ANALYSIS to the PBWLMS.SALES_ANALYSIS.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply