Multiple Server query
From: Chris W (psichiboy_at_yahoo.com)
Date: 04/27/04
- Next message: Alyx: "Stipping all alpha characters from a string"
- Previous message: Hari: "Re: Table Corrupt"
- Next in thread: Steve Kass: "Re: Multiple Server query"
- Reply: Steve Kass: "Re: Multiple Server query"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Apr 2004 07:23:49 -0700
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: Alyx: "Stipping all alpha characters from a string"
- Previous message: Hari: "Re: Table Corrupt"
- Next in thread: Steve Kass: "Re: Multiple Server query"
- Reply: Steve Kass: "Re: Multiple Server query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
- Re: .NET data provider or OLEDB provider?
... >I don't see where you see a built-in query engine. ... >service provider,
... >OLE DB providers don't have to support SQL however, ... > SQL Server
linked server, SQL Server can handle the queries. ... (microsoft.public.data.oledb) - How do I registry the OLE provider for a Exchange 2003 database
... I receive the following error when I try to query an Exchange database using ...
Could not locate registry entry for OLE DB provider 'exoledb.DataSource.1'. ...
How do I registry the OLE provider for a Exchange 2003database. ... (microsoft.public.exchange.connectivity) - Re: Linked server to Oracle
... One scenario where you can get the error is with data types ... Can you query
the tables using just an Openquery in Query ... make sure you are using the latest provider,
... I'm using MS OLE DB for Oracle. ... (microsoft.public.sqlserver.connect) - Re: Zugriff auf Active Directory
... An error occurred while preparing a query for execution against OLE DB ...
provider 'ADSDSOObject'. ... OLE DB error trace [OLE/DB Provider 'ADSDSOObject'
... (microsoft.public.de.sqlserver) - Re: Zugriff auf Active Directory
... FROM OPENQUERY(ADSI, ... An error occurred while preparing a query for
execution against OLE DB ... OLE DB error trace [OLE/DB Provider 'ADSDSOObject'
... (microsoft.public.de.sqlserver)
