Questions tagged as 'linked-server'

1
answer

Accessing SQL Server 2008 data from MySQL

Does anyone know if I can access data from a SQL Server 2008 database from a MySQL database? It would be something like Linked Server, but otherwise.     
asked by 11.09.2017 / 19:35
1
answer

Connect MS SQL to PGADMIN

Hello, good afternoon! I need to know if there are any tools, scripts or anything else where I can have the following scenario: I have an MS SQL database however I need to manipulate it through pgAdmin (postgres). Cnosegui do the invers...
asked by 15.05.2018 / 21:33
1
answer

Linked SQL Server and FireBird: Error 'Must declare the scalar variable'

I made a linked of my SQLSERVER with FIREBIRD . But at the time I pass a variable inside the query to return the record amount I get the error:    Message 137, Level 15, State 1, Line 1 Must declare the scalar   variable "@QtdR...
asked by 11.10.2017 / 03:49
0
answers

Error doing Linked Server with Firebird Bank

I installed Firebird 2.5 and the appropriate ODBC driver on my computer. I tested the connection and it worked, I called DB DB . But when I create the linked server in SQL Management Studio 2008, it gives me the following error, number 7303:...
asked by 17.10.2017 / 15:49
0
answers

How to do linked server with Oracle database for SQL Server 2008 (and considering VPN connection)?

I need to create a Linked Server connection to my client's SQL Server 2008 database. This Linked Server will be with an Oracle database. My SQL Server 2008 database is on a client-side server. The Oracle database is located on another remote...
asked by 27.03.2017 / 15:02
0
answers

Linked Server Optimization SQL Server

Currently there is an environment that has 4 servers with a database. I need to gather some information from 3 servers in 1. Example : The servers are: A B C and D I need to get some information that is on the A B C server...
asked by 13.07.2016 / 15:11
0
answers

SQL Server: error 7303 (architecture mismatch)

I've researched a lot, but I have not found a solution for my case yet. I need to create a linked server for a database in Access (mdb file). I use SQL Server 2012 Express x64 on Windows 8.1 x64. I ran odbcad x32 (which is inside the syswow64 fo...
asked by 14.08.2015 / 20:10
0
answers

The operation could not be performed because OLE DB provider "MSDASQL" for linked server "XYZ" was unable to begin a distributed transaction

I am trying to perform a update on a database on another server through a LINKED SERVER configured on my local server. I've tested it and it works perfectly when I use queries in the DBMS. In my web application, I use hibernate 3.5 and wh...
asked by 10.04.2015 / 19:28
1
answer

How to transfer data from one table to another on different servers

I need to copy the records of a table that is in a MySQL linked server to SQL Server, ie transfer the records from one server to the other. Could someone give me a way to do this through a query ?     
asked by 17.07.2018 / 19:29
1
answer

create Linked in MySQL between different instances [duplicate]

Hello, I have Instance A (Local) and another instance B, I need to do a query where I have table A (Local instance) relate to table B of (instance B) is possible?     
asked by 17.09.2018 / 21:07