July 30, 2004 at 5:21 am
Hi all,
I have 2 SQL 7.0 servers which are linked.
On the linked server are several databases. Permissions for these databases appear to be set up correctly across all of them to allow remote access.
HOWEVER: when I attempt to link via SPROC or Query Analyzer to X databases I get the following message:
Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' does not contain table '"db_x"."dbo"."tbl_y"'.
Now I know what this means, BUT in this instance the table I'm looking at is owned by dbo, as are all the other tables in the database - none of which can be accessed. I've checked the permissions on the database as compared to the criteria set in the original link and all seems well.
Other databases on the server are fine however.
Does anyone out there have any ideas...???
Mr Shouty
July 30, 2004 at 10:34 am
It has to do with the double quotes. I just recently dealt with this also. I'm sorry I can't remember the exact circumstances, but when I got rid of the double quotes around each piece of the qualified table name, it worked.
ie - '"db_x"."dbo"."tbl_y"' should be 'db_x.dbo.tbl_y'.
Steve
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply