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
2 answers

Query SQL Server database from MySql?

I am trying to find a work around to expedite our contractors work on our new website. The website is being created in WP using MySql, and some data that the website will dynamically load is located on our business SQL Server. Migration is out of…
mattgcon
  • 4,768
  • 19
  • 69
  • 117
0
votes
0 answers

Microsoft.ACE.OLEDB.12.0 Driver error

I have a statement that loads data from flat file to a database table, but it throws an error. The statement that I am using is: INSERT INTO emp_scd(empno,ename,hiredate) SELECT empno,ename,hiredate FROM …
Yousuf Sultan
  • 3,055
  • 8
  • 35
  • 63
0
votes
1 answer

Ms Sql Check linkedserver connection check from trigger

I'm trying to create a trigger which will insert some data into a table on a linkedserver in Ms Sql 2012. I want to be able to check if the server connection is active and if it isn't then I want to log the message else where but not abort the…
GimpArm
  • 23
  • 5
0
votes
2 answers

Performance hit on DB2 transactional database after linking to SQL Server 2005

We have an AS400 mainframe running our DB2 transactional database. We also have a SQL Server setup that gets loaded nightly with data from the AS400. The SQL Server setup is for reporting. I can link the two database servers, BUT, there's concern…
sothatswhereitgoes
  • 23
  • 5
0
votes
0 answers

Errror on creating a linked server.....Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server

Please see screenshot attached below:I go into the object explorer below, expand the linked servers node and right click the linked server I need and click "Test Connection" and I get the same error as discussed in this thread. I am trying to write…
Utpal Mattoo
  • 890
  • 3
  • 17
  • 41
0
votes
2 answers

linked server update mysql not working

i'm trying to update mySQL table via linked server MSSQL. My query looks like this: update openquery(CASTOMYSQL, 'select * from results_dwh_d where id_family = 0') set id_region = 0 When i execute this query and values in column id_region are not…
Karol Marian Słuszniak
  • 335
  • 1
  • 12
0
votes
1 answer

Linked servers select taking way to long

Moving some complicated reporting sprocs to a centralized server and time went from 5 seconds to 30+ seconds. validating what take so long via: print '04 NWA Raw data Numeric' print datediff(ss, @now, getdate()) set @now = GETDATE() I am…
SteveO
  • 477
  • 2
  • 9
  • 17
0
votes
1 answer

How to access two different linked servers in the same query

I am trying to access tables from two different linked servers. Basically from one server I get the list of id's and from the other linked server, I need to get two other columns whose id's match. I tried to get the id's first from one server and…
Mekala
  • 21
  • 3
0
votes
3 answers

SQL - Update command with subquery and linked server

I'm currently attempting to run an update on a table using a linked server Ex. update table1 a set a.column1=(select Count(b.column1) FROM linkedserver.databse.table b) where a.column2=b.column2 and a.column3=b.column3 My problem is: The multi-part…
imbrian21
  • 121
  • 8
0
votes
2 answers

Linked server "Data source name not found and no default driver specified" error

I made a linked server with Microsoft OLE DB Provider for ODBC Drivers: EXEC master.dbo.sp_addlinkedserver @server = N'TEST', @srvproduct=N'Microsoft Visual FoxPro Driver', …
Me5
  • 1,705
  • 3
  • 13
  • 19
0
votes
1 answer

Making backup from database to another server

I have a host on a server and that contains an SQL Server Database. I have another server in another country and i want have a backup from the database every 5 minutes or after each transaction only insert new row to another database. After some…
Saman Gholami
  • 3,416
  • 7
  • 30
  • 71
0
votes
1 answer

Is it okay to use SSIS for 1000 to 2000 records over linked Server

I just confused what to use SSIS or Linked Server.I have to transfer around 1000 to 2000 records into remote SQL server.Will it(SSIS) be a big hammer for 1000 to 2000 records (Also it is complex from maintenance perspective) Can you please help me…
Sachin
  • 57
  • 1
  • 1
  • 11
0
votes
0 answers

Cannot initialize the data source object of OLE DB provider “MSDASQL” for linked server

I am familiar with this post on the matter. I have the same situation as described in this post, however the accepted answer is not solving my problem. SPECIFICS From my Microsoft SQL Server 2012 console, logged in as Administrator (with domain…
dthree
  • 19,847
  • 14
  • 77
  • 106
0
votes
1 answer

SQL Server Trace Queries from Linked Server

I've got a SQL Server 2005 instance and I have a table that I'd like to trace, which we'll call Table1. I also have a linked server, which will query Table1. If I set up my trace, it will capture events if I query from the host. If I query from…
hughball
  • 50
  • 7
0
votes
2 answers

Create local Linked Server using Server Name or IP Address?

Based on the answer I received on this question (https://stackoverflow.com/questions/1911969/...) I have set up a Linked Server on SQL Server 2008 to a Pervasive database. Since both databases are on the same physical server, what would be the…
NinjaBomb
  • 785
  • 2
  • 13
  • 29
1 2 3
…
99 100