The linked-server tag has no wiki summary.
0
votes
1answer
63 views
Cannot see linked server properties in SQL Server 2008 R2
I configured a linked server in SQL Server 2008 R2; mirroring what currently exists in SQL Server 2000.
When viewing the properties of an existing linked you, you cannot see (or edit) any ...
3
votes
3answers
206 views
if I select more than 15 fields, I get catastrophic failure
Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it.
When I do select * or select field1,field2,field3....field15 I am getting this error:
Msg 7399, Level 16, State 1, ...
0
votes
0answers
63 views
accessing a linked server but cannot select
I have a linked server to a pervasive sql 11 database from my sql server 2012 64bit using ODBC
I am able to see the databases on this server, but when I select * from any table I am getting this ...
0
votes
0answers
89 views
linking pervasive sql to sql server as a linked server using odbc
I have been trying to establish a linked server on my sql server 2012 to pervasive sql v11 this way:
EXEC sp_addlinkedserver
@server = 'kslap208',
@provider = 'MSDASQL',
@datasrc = ...
1
vote
2answers
194 views
Authenticating Linked Servers - SQL Server 8 to SQL Server 10
We have an old SQL Server 2000 database that has to be kept because it is needed on our manufacturing machines. It also maintains our employee records, since they are needed on these machines for ...
0
votes
0answers
132 views
cannot create linked server with ms sql2008 and mysql
I am trying to create a linked server object in my 2008 r2 MSSQL Server using an ODBC connection. I have installed the latest 64bit MySQL ODBC driver. Testing this connection everything is fine.
I ...
0
votes
2answers
49 views
Can not create a linked server between SQL Server 2008 on a desktop and my laptop
I'm having an issue getting the linked server to connect between a desktop and my laptop. Both have SQL server 2008 and the link is coming from the desktop to my laptop. Also, both computers have ...
0
votes
1answer
201 views
Create ODBC Connection from Access to SQL Server
I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with ...
0
votes
1answer
268 views
How do I add a linked server in SQL Server 2008?
I want to pull some data into my queries from a remote server (also SQL Server 2008), because some related data is on the remote server but not the local server.
The "add linked server" wizard in SQL ...
1
vote
1answer
227 views
Adding a linked server via Powershell
I'm trying to add a linked server to my local SQL Server 2008 R2 setup from within a Powershell script.
Here's what I've been trying so far (and variants):
EXEC master.dbo.sp_addlinkedsrvlogin
...
0
votes
2answers
4k views
How to successfully connect to Foxpro database files using MSSQL Linked Server feature and ODBC?
We're trying to access Foxpro file-based database files via MSSQL Server's linked server feature, using Foxpro ODBC driver.
For this, we've
installed the latest Foxpro ODBC Driver from Microsoft,
...
-1
votes
1answer
579 views
Create linked server from SQL Server 2008 to Intersystems Caché
The linked server has been created but failed a connection test. Do
you want to keep the linked server?
An exception occurred while executing a Transact-SQL statement or
batch. ...
0
votes
1answer
289 views
Error when connecting to Named Instance as a Linked Server
I have a MS SQL2008 server running a root instance and a named instances.
SQL001\.
SQL001\Pilgrim
When I connected to SQL001\Pilgrim I can set-up a link to the default instance SQL001\. no ...
1
vote
0answers
169 views
SQL 2005 to SQL 2000 Linked Server Update Error
I have a linked server from a 2005 instance to a 2000 instance that I am getting an error when trying to do an Update accross the linked server. This Update has worked for the past 2 years without ...
2
votes
2answers
292 views
Transfering BLOBS on a MSSQL -> MySQL Linked Server
Working on setting up a new MySQL database for a website, and I'm trying to figure out how to transfer over long strings.
I have quite a few MSSQL tables that have Varchars ranging from 500 to 2000.
...
0
votes
1answer
277 views
Linked server to MSSQL from MySQL
We are working on setting up a linux server with MySQL on it as a testing server. I got a linked server set up on our current MSSql server so that we can query the MySQL server, but I would also like ...
6
votes
5answers
4k views
Double hop problem with sql server 2008
I'm trying to set up the following scenario. I have 3 servers, they are all in same domain.
Server A has web application which runs under (domain) service account, dom\web.
Server B has instance of ...
0
votes
0answers
151 views
SQL 2005 linked server to MS Access 2003 breaks after a while
On our production server, I linked to an unsecured Access 2003 mdb file which worked nicely for a few days.
EXEC sp_addlinkedserver 'NUWDB', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', ...
1
vote
1answer
2k views
MS SQL 2008 - Setup Oracle Linked Server [SERVICE_NAME not given error]
I'm trying to setup a linked server on MS SQL 2008 R2 to an Oracle 11g server. I've got the Oracle client installed and sqlnet.ora, tnsnames.ora & listener.ora copied from the server and in place ...
0
votes
1answer
459 views
sql Server 2008 R2(64 bit) and oracle 10g linked server
we are migrating from our old SQL server 2005 (32 bit) to a windows server 2008 R2 with SQL server 2008 installed on it (64 bit) . in the old server we had a linked server to our other server which ...
0
votes
0answers
307 views
Linked server problem on SQL Server 2005
I have a weird issue and I hope someone can steer me in the right direction for resolving this please. When I execute the following query against a linked server, I get the following error. I can ...
1
vote
1answer
198 views
Problem adding Oracle to SQL 2005 as a Linked Server
I have a SQL 2005 server that I need to link to an Oracle server.
I've installed the Oracle client, and followed several sets of instructions found online. I have an error every time I test the ...
1
vote
1answer
383 views
SQL Server 2008 Replicating Linked Server Tables
I have a SQL2008 server with a linked Sybase server. I have several tables on the SQL2008 server that I need have merge replicated to some SQL2008 Express clients. I also need to get two tables from ...
2
votes
1answer
355 views
How to create a shared lock blocking an intent exclusive lock
As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive ...
3
votes
2answers
11k views
How to install Oracle OLE drivers for use in SQL Server 2008 R2 x64
As per standard procedure we've been using for years for previous versions of both Oracle and SQL Server, I have installed Oracle's latest ODAC package, which includes the Oracle OLE driver onto our ...
0
votes
1answer
581 views
MSSQL 2005 > Linked Server Connection Fails > MSSQL 2000
At the company I work for, we currently are running 3xSQL 2005 servers and 1xSQL 2000 server. All of the 2005 servers can communicate with each other, however they cannot communicate with the 2000 ...
0
votes
1answer
376 views
Sql server 2005 linked server to 2008 error A severe error occurred on the current command
I am able to query few tables on the linked server but few tables are giving me this error.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, ...
4
votes
3answers
716 views
Can SQL Server 2008 Linked Servers be edited? Is there the equivalent of an ALTER statement for Linked Servers?
I have a Linked Server which was made using SQL Server Management Studio 2008.
If the linked server destination changes, I will have to change the properties of it to direct to the right place.
But ...
4
votes
2answers
2k views
how does ping resolve to ipv4 on one machine, but ipv6 on another?
Background
I have two environments, TEST and STAGE. I use Microsoft Distributed Transaction Coordinator (MS DTC) with two linked 2008 SQL servers. A SQL job runs every couple of minutes and ...
2
votes
1answer
1k views
Trigger is not working on LInked Server. Both servers are SQL Server 2005
I have link a server with another server. I can access records from linked server and I can also insert record using INSERT statement like
INSERT INTO [LINKED-SERVER-IP].MyDb.dbo.Customer ...
1
vote
4answers
2k views
Can we have Linked Servers when using NTLM?
I don't have access to the Active Directory settings, nor do I have access to change anything on the linked server.
From everything I've read, it seems like this means I cannot use Kerberos - which ...
0
votes
2answers
507 views
SQL Server 2005 - Oracle Linked servers stop working
[URGENT - PRODUCTION ISSUE]
All of a sudden, on a SQL Server 2005 instance, all the Linked Servers to Oracle stopped working. All other instances can connect to the linked servers without a problem ...
2
votes
2answers
979 views
SQL Server: severe error when querying a MySQL Linked Server
Hey, I have been having a problem with my linked servers. I am using Microsoft Server 2003 and Microsoft SQL Server Management Studio 2005.
The linked server is a MySQL database. It was defined ...
4
votes
2answers
5k views
How do I create a Linked Server in SQL Server 2005 to a password protected Access 95 database?
I need to create a linked server with SQL Server Management Studio 2005 to an Access 95 database, which happens to be password protected at the database level. User level security has not been ...
1
vote
1answer
827 views
How do I add a self-referencing linked server in SQL 2008
I am trying to replicate our live server set up local using a single SQL database.
In SQL 2005 I would added 2 linked servers both referencing itself with different names, each point to a different ...
0
votes
3answers
2k views
Access to the remote server is denied because no login-mapping exists
I've got a Linked Server in my SQL Express install that is using SQL Server Authentication.
I've created a SQL Server login-mapping and it's using Impersonate.
I've confirmed that the account exists ...
3
votes
4answers
1k views
Using linked servers to query across database servers?
We have multiple MSSQL 2005 servers that contain silos of information. We want our database developers to be able to join across these silos in the most transparent and performant way possible. The ...
0
votes
2answers
535 views
Backup a Linked MySQL DB through SQL Server Management Studio
I have a MySQL database that I'm able to query as a Linked Server through SQL Server Mgt Studio. I'm wondering if it's possible to create a backup task in Studio that will backup the MySQL DB, so that ...
2
votes
2answers
384 views
Linking to oracle from SQL Server 2005, this sucks
I need to create a link server from SQL Server to Oracle, but I'm having no luck.
I've install the oracle 10g client software and I'm able to use TOAD for oracle and use ODBC to connect to the ...
1
vote
1answer
367 views
linked-server sql - access
I have a SQL server 2000 and an Access database mdb connected by Linked server on the other hand I have a program in c # that updates data in a SQL table (Users) based data base access.
When running ...
2
votes
3answers
5k views
User cannot access a system DSN on Windows Server 2008
We run our SQL Server services using a low privileged domain account. That account is NOT a local admin on the OS. Only access I give the user account is assigned during install of SQL: full control ...
1
vote
3answers
280 views
Why can't I access stored procedures on a linked MSDE 8.x server?
I am trying to execute a stored procedure on a linked MSDE 8.x server by running the following SQL against the parent SQL Server 2000 instance...
DECLARE @RC int
EXECUTE @RC = ...
0
votes
2answers
687 views
execute a script against a table on a different instance
Scenario
Its pretty involved to explain but I have a procedure that updates data in two databases on instance1 and as part of the process (its a cursor for relevant reasons) it needs to make updates ...
0
votes
2answers
786 views
SQL Server crashes when remote query fails
Setup:
I have a linked server setup on SQL Server 2005 which is pointing to an Oracle DB. The linked server has RPC enabled.
Problem: When a query throws an exception on the remote server (Oracle DB) ...
0
votes
1answer
671 views
SQL Server 2005 - My Linked Servers to it are broken now!
I'm a programmer working over a VPN.
I use local databases most of the time, but my local SQL Server 2005 has "Link Server" server object pointing at the production server.
This has been working ...
