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

Trying to establish a linked share connection with SQLite from SQL Server

I am trying to create a linked share connection from SQL Server to SQLite. I have followed all the steps by Graham Okely in the below link. It was really nice and I have been able to create the linked share connection from SQL. Creating a Linked…
Gopakumar N.Kurup
  • 916
  • 4
  • 18
0
votes
1 answer

Connection to MSSQL from MySQL

I have a MySQL DB on Ubuntu Server. Is any possibility to establish a connection with remote MSSQL DB and use this DB in query? For example, execute in MySQL query like this: SELECT mysql_table.field1, mssql_table.field2 FROM …
user3240646
  • 123
  • 9
0
votes
1 answer

Eror when updating the mysql table on linked server, from mssql server

When I try to update my customer table that is on linked server, from my procedure on mssql server, I get this error: OLE DB provider "MSDASQL" for linked server "PRESTA" returned message "Row cannot be located for updating. Some values may have…
Admir Huric
  • 137
  • 8
0
votes
1 answer

SQL 2008 R2 SP2 Linked Server - Exclude certain databases

I have a linked server and I would like to exclude 4 databases in the link. Is there a way to "hide" them? Currently the users access via the AD groups they are in. Would I just revoke the AD groups?
Mochael_DLite
  • 167
  • 2
  • 5
  • 14
0
votes
0 answers

Make Access file with SQL Server linked table portable via Windows Authentication

I have a SQL Server which contains a table that needs to be updated by different people in different departments. The easiest solution that we came up was to create a MS Access file, and people can open the file to update the table using Trusted…
TSQL_Noob
  • 187
  • 1
  • 1
  • 12
0
votes
3 answers

"Cannot process the object" after release update from AS400 iseries i5 from V6R1 to V7R1

this statments work under V6R1 but not under V7R1 with an ODBC linked server in an SQL Server 2012 select * from AS400.AS400.LIB.TAB SQL Managment Studio thrown the error: Cannot process the object "AS400.LIB.TAB". The OLE DB provider "IBMDASQL"…
JJANSSEN
  • 171
  • 1
  • 6
0
votes
1 answer

Linking Oracle with SQL Server on Windows Server 2012

We have been using SQL Server's linked server capabilities successfully for over a year to connect to Oracle. We've been doing this under Windows Server 2008. Today, we moved the same setup to an SQL server that was installed on a Windows 2012…
Midas
  • 564
  • 6
  • 21
0
votes
1 answer

Accessing an OLEDB source through Java

I have a Java app that needs to access a 3rd party database through OLEDB. Does anyone know of a way to do this? I am looking for an answer from the year 2014 on this question - everything I have seen so far is from a few years ago and basically…
dhalia
  • 401
  • 5
  • 21
0
votes
0 answers

Linked Server as Database

I successfully created a linked postgresql server in SQL Server 2008. I can also query results using SELECT * FROM OPENQUERY(POSTGRES32,'SELECT * FROM public.categories') Is there a way to treat that linked server (Postgresql) as a SQL Server…
user3204806
  • 322
  • 4
  • 15
0
votes
1 answer

Linked server dynamic catalog for executing MDX through OpenQuery

I have multiple OLAP databases in my project, so is it possible to dynamically decide the catalog for executing this MDX query? SELECT * FROM OpenQuery(OLAP_SERVER, 'WITH MEMBER measures.X AS dimensions.count SELECT Measures.X ON 0 FROM MyCube') as…
Manish Surolia
  • 85
  • 1
  • 12
0
votes
1 answer

MySQL > SSMS 2012 Linked Server "Requested conversion is not supported."

This little gem has kept me going for a wee while now and I'm still not much further forward. Environment SSMS 2012 SP1 (target) (Server 2012 64 bit) MySQL (source) Linked server using ODBC 5.3 64bit Unicode driver I am trying to port the tables…
Nique
  • 13
  • 1
  • 5
0
votes
0 answers

Linked Server Performance Issues

I've created a linked server for an Access database from MSSQL that takes a very long time to return rows. I'm using SQL Server 2005 and the Access database is 2003. A select statement in SSMS of 8 columns and 80,000 rows takes 60s to run. I gave…
shadowjfaith
  • 932
  • 8
  • 14
0
votes
1 answer

Stored Procedure to Insert the result of a parameterized OPENQEURY into a local table

So this is "fun", and by "fun" I mean mindbending. I have managed to: Feed parameters to OPENQUERY and get results like this: Declare @MyString varchar(max) , @TheDateAfter datetime set @TheDateAfter = DATEADD(d, 1, @TheDate) set …
n8.
  • 1,732
  • 3
  • 16
  • 38
0
votes
1 answer

AS400 DB2 national characters into SQL Server linked server

I have a SQL Server 2012 Enterprise edition linked server connection to an IBM AS400 DB2 database. I am using the IBMDASQL provider for the connection. I have problems with some Hungarian characters: the letter Ő is converting to O during the…
Tomi7979
  • 53
  • 6
0
votes
0 answers

SQL Server Remote Update

We have a process in which several site servers send data to a central server (through a Linked Server). A new site has seen the job duration more than double in three weeks, and a couple of the other sites often fail due to run time overlap. It is…
Dave Johnson
  • 825
  • 16
  • 27
1 2 3
…
99 100