Most voted "linked-server" questions
None
Learn more…12 questions
Sort by count of
-
3
votes1
answer39
viewsAccess SQL Server 2008 data from Mysql
Does anyone know if I can access data from an SQL Server 2008 database from a Mysql database? It would be something like Linked Server, but the other way around.
-
2
votes1
answer214
viewsLinked SQL Server and Firebird: Error 'Must declare the scalar variable'
I made a Linked of my SQLSERVER with the FIREBIRD. But when I pass a variable inside the query to return the amount of record I get the error: Message 137, Level 15, Status 1, Line 1 Must declare…
-
1
votes0
answers89
viewsThe Operation could not be performed because OLE DB Provider "MSDASQL" for Linked server "XYZ" was Unable to Begin a Distributed transaction
I’m trying to accomplish a update in a database on another server through a LINKED SERVER configured on my local server. Already tested and is working perfectly when using darlings in the SGBD. In…
-
1
votes0
answers91
viewsSQL Server: error 7303 (Architecture Mismatch)
I’ve done a lot of research, but I haven’t found a solution for my case yet. I need to create a Linked server for an Access database (mdb file). Use SQL Server 2012 Express x64 in Windows 8.1 x64. I…
-
1
votes0
answers131
viewsLinked Server SQL Server Optimization
Currently has an environment that has 4 servers with database. I need to gather some information from 3 servers in 1. Example: The servers are: To B C and D I need to get some information that’s on…
-
1
votes0
answers40
viewsHow to make 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 in a server of my client. The…
-
1
votes0
answers167
viewsError doing Linked Server with Firebird Database
I installed Firebird 2.5 and the due ODBC driver on my computer. I tested the connection and it went all right, I called the bank DB. But when I create Linked server in SQL Management Studio 2008,…
-
1
votes1
answer152
viewsConnect MS SQL in PGADMIN
Hello, good afternoon! I need to know if there is any tool, script or anything else from where I can have the following scenario: I have a MS SQL database but need to manipulate it through pgAdmin…
-
0
votes1
answer685
viewsHow to transfer data from one table to another on different servers
I need to copy the records of a table that is in a Linked Mysql server to SQL Server, that is, transfer the records from one server to the other. Could someone tell me a way to perform this through…
-
0
votes2
answers325
viewsHow to insert data into another database with Linked Server
Good afternoon! How do I create a trigger that uses a Linked Server to insert the INSERTED data in another table that is in another database, this in another server? Trying to Exemplify: CREATE…
-
0
votes1
answer764
viewsHow to Select Tables in Different SQL SERVER 2008 and 2012 Databases
Currently I have 1 database in SQL SERVER 2008R2 and another SQL SERVER 2012. I HAVE AN APPLICATION THAT USES THE BASIS IN 2008R2 AND I NEED TO CONSULT DATA THAT IS IN 2012. WHICH IS THE BEST WAY?…
-
-1
votes1
answer117
viewscreate Linked in Mysql between different instances
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 ?