Linked server allows operation to multiple server as one query.
1
vote
1answer
302 views
Get statistics of open connection to linked servers
How can I get information about connections from my MS SQL 2008 server to linked servers (actually it's an Oracle db)?
Things like number of currently open connections, and history of opened and ...
1
vote
1answer
60 views
How do I specify a linked server to a remote database over tcp/ip?
I have a remote database running on an IAAS provider and I need to be able to execute joined queries from my local workstation. I am having trouble because when I attempt to create the link it is ...
1
vote
2answers
123 views
Sql Server Linked Server
I have two sql server S1(2008) and S2(2005).
S2 is added to S1 as linked server.
S2 have a table Product.
When I try to run the code
select ProductID from Product
I get the error:
Location: ...
1
vote
1answer
310 views
Which reporting method has better performance, using linked server or using lookup in SSRS?
I've been using the new lookup function in Reporting Services 2008 R2 when using different servers where I don't have the option of a linked server. However, the DBA just created the a link to that ...
1
vote
2answers
91 views
Working Linked Server Query fails in sp_send_dbmail
Take the following example:
EXEC msdb.dbo.sp_send_dbmail
@recipients = 'me@whatever.co.uk' ,
@query = 'SELECT TOP 10 * FROM LINKEDSERVERA.DATABASE.dbo.TABLE' ,
@attach_query_result_as_file = N'True' ...
1
vote
1answer
132 views
Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server
I'm trying to establish a linked server from SQL Server 2008 R2 to an Access database. The Access database is not password protected. As I have seen in other posts (specifically this one), this is ...
1
vote
1answer
1k views
Create a linked server with SQL Server 2012 x64
How can I create a linked server to a folder having fox pro dbf files?
I can access the dbfs inside Visual Studio 2010, creating a connection with this properties
Connection string
...
1
vote
4answers
1k views
Select from linked server to local server causing waits on both sides
The queries in question are here: http://pastie.org/4833351
Run individually, each of these queries runs through (albeit slow).
Run as a group, it just sits there, showing either OLEDB waits on the ...
1
vote
2answers
110 views
Replacing the MS-Acccess frontend for accessing linked tables with SQL Server?
Is it possible to use SQL Server / SQL Server Management Studio to do queries across linked tables the way that you would do them in MS-Access?
The MS-Access front-end is frustrating and time ...
1
vote
2answers
434 views
SQL server moved, now can't use as linked server
So I have a SQL server database that was controlled by an outside vendor. It is hosted remotely. Then he needed to move the server to a new host. Now, I'm able to connect to the server manually ...
1
vote
1answer
659 views
SQL Server Linked Server Permissions
On a SQL Server 7 server, I have a linked server to a Sybase database server.
select * from openquery(SYBASE_SERVER, 'select * from DBA.TESTTABLE')
works fine if I'm logged in as an SA.
If I try to ...
1
vote
1answer
767 views
Is there a syntax for accessing table names containing slashes?
I have a linked server registered in my SQL Server 2005 which accesses our SAP database (test system). It uses an ODBC driver provided by SAP, and is connected using the Microsoft OLEDB For ODBC ...
1
vote
1answer
116 views
MySQL - run SELECT statement on another server without defining the table structure
In MySQL I can query information on another server using federated tables, as long as I've defined the same table structure locally.
In MS SQL Server, however, I can run any SQL statement against a ...
1
vote
0answers
60 views
sp_testlinkedserver taking long time to time-out
I'm using the following code to check if a linked server is available before running queries on it:
declare @srvr nvarchar(128), @retval int;
set @srvr = 'my_linked_srvr';
begin try
exec @retval ...
1
vote
2answers
187 views
SQL Server update query on linked server causing remote scan
I have a SQL Server 2012 setup as a linked server on a SQL Server 2008 server.
The following queries executes in less than 1 second:
SELECT kg.IdGarment
FROM Products p
INNER JOIN ...
1
vote
0answers
58 views
What permissions are required to view the contents of a catalog on a remote server?
I defined a linked server from a SQL Server box to a MySQL box. I went through a very detailed set of instructions and steps, everything works like a charm when I am logged in.
The linked server ...
1
vote
1answer
95 views
Does Oracle server installation include client components?
I installed Oracle personal edition on a Windows Server 2008 virtual machine for testing purposes. My intention is to test Linked server functionality with SQL Server. Does Oracle Server installation ...
1
vote
0answers
110 views
Cannot Check if the Access Database Engine is Installed and Configured
All, I want to check if the Access Database Engine is installed and linked to SQL Server. On my development machine (x64-bit) the following queries both show the Access Engine to be avalible as a ...
1
vote
0answers
161 views
Update excel sheets from SQL Server 2005 linked servers
I use SQL Server linked servers to connect to Excel 2003 multiple tabs workbook. After connected, I have not problem to use select statement like:
select * FROM OPENQUERY(TEST, 'select * from [fist ...
0
votes
1answer
60 views
BUILTIN\Administrators allowing access via linked server but not locally
We have two servers:
LYNDB01 & LYNDB02
On LYNDB01 we have a database called db_ExampleDatabase
We have created a Linked Server on LYNDB02 to LYNDB01 using no mappings and the "Be made using the ...
0
votes
2answers
96 views
Linked Server to SQL Server 2000 server from SQL Server 2012
I have a new SQL Server 2012 instance, and am migrating a database from SQL Server 2000. Some of the stored procedures in the DB I am moving reference another database back on that 2000 server. What ...
0
votes
1answer
79 views
How can I install a provider for linked server?
I have a provider for a linked server called PervasiveOLEDB.11.0 installed on a sql server 2005 machine. It always me to have a connection to a pervasive sql database.
I would like to use this same ...
0
votes
1answer
299 views
How do I connect to a database which is a linked server via ODBC?
(All the searches for this sort of thing tell me about where the linked server is connecting to the original database via ODBC, but I'm connecting to the intermediate server via ODBC.)
I have a ...
0
votes
2answers
3k views
How to add linked server SQL Server 2008 R2
I have two SQL Server 2008 located in different cities.
I have physical access to one of them and I can exec SQL Server Management Studio there.
For second server I have following parameters:
...
0
votes
1answer
2k views
The OLE DB provider “SQLNCLI” for linked server X reported a change in schema version between compile time X and run time X for table [tablename]
The below error starts happening once a week at the same time every week.
The OLE DB provider "SQLNCLI" for linked server X reported a change in schema version between compile time X and run time X ...
0
votes
1answer
326 views
How to fix “The OLE DB provider ”MSOLAP“ has not been registered”?
Here's the code I'm using to register a linked server to SSAS:
USE [master];
GO
EXEC master.dbo.sp_addlinkedserver
@server = N'ServerAlias',
@srvproduct = N'',
@provider= N'MSOLAP',
...
0
votes
2answers
1k views
SQL Server : Is it possible to have a linked server link to another linked server?
Hello to all and thanks ahead of time for taking the time to look at my question!
I'm trying to do a work-around to access a 32bit Advantage Database Server 8.1 database with 64bit SQL Server 2008R2.
...
0
votes
1answer
298 views
Strange Sybase / SQL Server linked server issue
I have a sybase table which has a column note varchar(1000) null.
The following T-SQL will get the following error if there is a not-null value in note. (sybase is the linked server to the Sybase ...
0
votes
0answers
27 views
EXECUTE AS over Linked Servers
I have a front end that logs into the DB as "logInA", and only has permission to "schemaA" stored procs, which use EXECUTE AS "logInB", (I have also tried EXECUTE AS 'DBO'), to handle all the business ...
0
votes
0answers
87 views
SQL Server link to linked server
My client has a Visual FoxPro database that needs to co-mingle with SQL Server data (SELECT only, no updates or deletes).
After quite a bit of searching I found the VFP OLEDB provider doesn't work ...
0
votes
1answer
364 views
check if linked server table column exists
I have several access databases that I'm copying over to the sql server, connecting to as a linked server, and then pulling data from each night.
I need to be able to identify if the current access ...
