Re: Multiple Server query
From: Steve Kass (skass_at_drew.edu)
Date: 04/28/04
- Next message: Lind: "Calculated field in a calculation."
- Previous message: Vishal Parkar: "Re: Stipping all alpha characters from a string"
- In reply to: Chris W: "Multiple Server query"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Apr 2004 02:38:21 -0400
Chris,
It seems more likely that you would want
select * from SVR2.TESTDB..TESTTBL
though I'm not quite sure why you get this particular error. What did
you use to add the server SVR2?
Steve Kass
Drew University
Chris W wrote:
>I'm trying to write a query that will be used in a stored
>proc to grab data from a table on a different server.
>So I have SVR1 trying to get data from SVR2, so I'm trying
>to use this query:
>
>SELECT * FROM SVR2..TESTDB.TESTTBL
>
>but I get the following error:
>OLE DB provider 'SVR2' does not contain
>table '"dbo"."master"'. The table either does not exist
>or the current user does not have permissions on that
>table.
>OLE DB error trace [Non-interface error: OLE DB provider
>does not contain the table: ProviderName='SVR2',
>TableName='"dbo"."master"'].
>
>
>Can anyone help?
>
>Thanks,
>Chris
>
>
>
- Next message: Lind: "Calculated field in a calculation."
- Previous message: Vishal Parkar: "Re: Stipping all alpha characters from a string"
- In reply to: Chris W: "Multiple Server query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
- Re: Crystal XI troubles
... It turned out to be a permissions issue. ... was that I am using the OLE
DB provider for Oracle. ... (microsoft.public.dotnet.framework.adonet) - Re: Connecting to Access
... "John Bell" wrote in ... > OLE DB provider 'Microsoft.Jet.OLEDB.4.0'
reported an error. ... > 0x80004005 indicates a permissions issue. ... (microsoft.public.sqlserver.programming) - Re: Query Excel
... It looks to me like you've got some extra spaces, ... >OLE DB provider
'Microsoft.Jet.OLEDB.4.0' does not contain ... >current user does not have permissions
on that table. ... (microsoft.public.sqlserver.programming)
