I have开发者_运维知识库 setup a linked server from sql server to DB2. For some strange reason \'@\' is appearing in the result set from a query that performs where not exists between tables of sql ser
For various horrible reasons, we\'ve had to link SQL Server to a MySQL database using Linked Servers and an ODBC Data Source. The queries run fine, but looking at the query plans you can see that SQL
I am trying to execute this query against Oracle linked server, and getting the following error, which I know that my query is malformed, but I couldn\'t figure out where and how.
I have to run several queries on a set of linked servers.I want to try and do it without resorting to dynamic sql, but having trouble so far.
I have a SQL Server instance that I\'ve added a linked server to another SQL instance. The table I\'m accessing on the linked server contains spatial types. When I try to que开发者_运维技巧ry the tabl
How can I find the address of defined linked server in SQL Server开发者_如何学运维 2008? The link server is present and its connection test shows there is no problem. but I can not find where the link
How do I select a blob column from an Oracle database using OPENQUERY on a SQL Server that is using Linked Server to connect to the Oracle database?
We\'re doing a sort of roll-your-own replication from a SQL Server 2008 R2 database to a MySQL 5.1 database.This isn\'t true replication, as the MySQL box is acting as permanent storage and the SQL Se
I have a linked server (Sybase) set up in SQL Server from which I need to draw data. The Sybase server sits on the other side of the world, and connectivity is pretty shoddy. I would like to insert da
I need to setup a linked server on my new sql 2008 R2 server but there is no oracle data provider in providers list of my server and when I\'m trying to install oracle client or oracle data 开发者_高级
加载中,请稍侯......