April 2, 2009 at 5:04 am
When I do a
SELECT * FROM [LinkedServer].DatabaseName.dbo.Table1
I get results 😀 , but when I do
SELECT * FROM [LinkedServer].DatabaseName.dbo.Table2
I get :crazy: Invalid schema or catalog specified for provider 'SQLOLEDB'
The table which fails has some int columns and some nvarchar columns. Nothing unusual. Even worse is if you run it directly from the server itself (SELECT * FROM DatabaseName.dbo.TableX) then both tables successfully return results.
April 2, 2009 at 6:50 am
Have you verified that the linked server user has Select permissions on the table(s) where the queries are failing?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 2, 2009 at 7:09 am
Jack Corbett (4/2/2009)
Have you verified that the linked server user has Select permissions on the table(s) where the queries are failing?
Yes.
However I have finally tracked down the answer: For anyone else out there googling for the answer....
The table has a space at the end of it's name :pinch:
I'm going to kill the developer responsible later :exclamationmark: For a quick fix I've put in the ol' [] around the name including a space
SELECT * FROM [LinkedServer].Database.dbo.[TableWithStupidName ]
April 2, 2009 at 7:13 am
Ouch! How does anything work that is accessing that table?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply