Stack Overflow
Stack Overflow

Questions tagged [linked-server]

The SQL Server "linked server" feature makes it possible to execute commands, such as a SELECT statement, on a remote server.

Use this tag for any questions related to SQL Server's linked server feature.

A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers. Linked servers offer the following advantages:

  • Remote server access.
  • The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.
  • The ability to address diverse data sources similarly.

An OLE DB provider is required for this functionality to work.

See MSDN for more information.

1493 questions
0
votes
3 answers

Create a Linked Server for a MySQL Database in SQL Server 2005

I'm currently trying something I've never done before - I'm trying to access MySQL data in an SQL Server environment. Where I am, we have two servers (the MySQL and MSSQL servers), and each stores different types of data. Recently I've found a need…
RoboBear
  • 5,434
  • 2
  • 33
  • 40
0
votes
1 answer

Transaction with loopback linked server - locking issues

I have two databases A and B. They are both stored on one database instance. I created a loopback linked server on the instance. Database A contains one table dbo.Users and one stored procedure updating dbo.Users table. In database B I have a query…
Adam Łepkowski
  • 2,048
  • 1
  • 24
  • 41
0
votes
1 answer

Consolidation of MSSQL Databases

I am trying to bring databases from different instance/server (MSSQL 2008 R2) to single MSSQL Server/Instance. Existing databases have cross references/linked server used in code, so when I will simply be restoring databases from source to…
Nishad
  • 426
  • 2
  • 7
  • 20
0
votes
1 answer

Change password in ORACLE from SQL Server via linked server

I have an Oracle database connected to a SQL Server. The connection works correctly, but unfortunately, I don't know the password used for that connection. Now I need to change the password in Oracle. Is it a good idea to run something like SELECT *…
Dzmitry Paliakou
  • 1,587
  • 19
  • 27
0
votes
1 answer

64-bit SQL Server Linked server to SyBase via 32-bit ODBC driver

What I have: a 64-bit SQL Server 2012 installed on Windows Server 2008R2 32-bit ODBC driver SyBase ASE 12.5.1 (and I have no ability to obtain any other official driver) What I need: access from SQL Server to SyBase Adaptive Server…
Dzmitry Paliakou
  • 1,587
  • 19
  • 27
0
votes
0 answers

Data link to accdb file

I want to make a data link(Connection Managers) from SQL server 2012, 64 bit to an accdb Microsoft access 2013 file. I am using Microsoft office 12.0 Access Database engine OLE DB Provider and I have changed the Run64BitRuntime properties to False.…
KOMAEI
  • 31
  • 1
  • 7
0
votes
1 answer

Cannot create an instance of OLE DB Provider 'OraOLEDB.Oracle' error when creating linked servers from SQL Server to Oracle

Aware that this topic has been raised many times here (I have gone through the posts), but none of the suggestion on the posts has resolved my issue. When I attempt to create a linked server to the oracle database from SQL Server Management Studio,…
ricky89
  • 1,326
  • 6
  • 24
  • 37
0
votes
2 answers

SQL Server - what permission need to open for view a table schema in a linked server

After creating a linked server on SSMS 2008, how should I see linked server table schema? Should I change any permission on remote SQL Server? Also, what commands can check those permissions for all accounts? Thanks. EDIT: running on SQL Server…
Stan
  • 37,207
  • 50
  • 124
  • 185
0
votes
0 answers

Intermittent OLE DB error from MSDASQL for OPENQUERY call to MySql

I have a SQL statement running in SQL Server 2012 that sometimes works fine (returns a little over 4,000 rows in about 25 seconds) and sometimes fails after about 9 1/2 minutes with the error: The OLE DB provider "MSDASQL" for linked server…
Mark Freeman
  • 1,155
  • 3
  • 24
  • 42
0
votes
2 answers

SSDT + LinkedServer = Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection

If anyone can assist with this issue, I’d be most grateful. I’ve been struggling with it for too long now, and can’t seem to resolve. I have an SSDT project (VS2012, SQL2008) with stored procedures that reference a linked server. The project builds…
Lenni Lobel
  • 21
  • 1
  • 6
0
votes
0 answers

Oracle Express Synchronization from Another Orable Database

I have a Oracle 10g database currently in a server. I will create a web which may have massive requests to get data from the Oracle 10g. So, to prevent degrade the Oracle 10g database and server performance, I would like to setup an Oracle Express…
daniel
  • 1,010
  • 6
  • 15
0
votes
2 answers

List of SQL servers linked to a particular server

If I have multiple SQL Servers and I want to display what are the Linked servers to the actual SQL Server (myServer1) I am connected to, I could execute sp_linkedservers or navigate under Server Objects/Linked Servers and that will show me a list of…
mcha
  • 2,938
  • 4
  • 25
  • 34
0
votes
1 answer

exporting a table containing a large number of records to to another database on a linked server

I have a task in a project that required the results of a process, which could be anywhere from 1000 up to 10,000,000 records (approx upper limit), to be inserted into a table with the same structure in another database across a linked server. The…
Mark Southwell
  • 1
  • 1
0
votes
0 answers

Linked server unaccessible after detach of unrelated database

We have 2 servers, Server1 which is local and Server2 which is the remote server. On Server1 there is a linked server configured for Server2. On Server1 there is a agent task which copies data from Server2 to Server1. This task did copy data to a DB…
user3104423
0
votes
2 answers

Linked Servers vs SSIS

When I want to move data between two databases, what better choice. A) Linked Servers database local-> Linked Servers -> database azure b) ETL - SSIS database local create procedure xml -> integration service -> serialize xml to object c#> call wcf…
Wandelson Bezer
  • 11
  • 1
  • 5
1 2 3
…
99 100