Connection from two servers

From: Oded Kovach (roygoldh_at_hotmail.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 12:53:24 +0200

Hello there

I have an sql server program which have 2 sql servers servers are registered

In the query analyser when i open connection to one of them and trying in
the query to access to the another server by the query:

select *
from ODED.web.dbo.cities
WHERE CityCode=1000

I get the error:
Server 'ODED' is not configured for DATA ACCESS.

what can cause it ?

any help would be useful

Relevant Pages

  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • Re: A CTE Question
    ... So I did not look at the DB2 solutions very closely, ... It is also amazingly close to Michel's original query. ... On SQL Server and Sybase, ... On SQL Server the default is that ...
    (comp.databases.ms-sqlserver)
  • Re: Efficient coordinated queries??
    ... :-) We are distributing processing over a large server farm -- bringing it back onto the SQL server would probably kill our performance. ... Hitchhiker's Guide to Visual Studio and SQL Server ... A large chunk of it can be brought in with a single query and each row represents an item to process. ... For a hypothetical example consider a customer order database where we need to process through all customers and can bring in a row of customer data as our main query but there are 0..n1 rows of customer order data, 0..n2 rows of customer feedback information, 0..n3 rows of customer discounts available, etc. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO across vpn
    ... Create client/server application that connects to SQL Server or some ... Create a web service the does all the data access and access the web ... >>> We have a vb6 application which connects via ADO to an access ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Server maxes out at 100% CPU!
    ... The CPU becomes pegged at 100%. ... there is a query from hell driving ... state occurs when a client does not pick up data as fast as SQL Server ... What you need to do is to run more detailed diagnostics when the server ...
    (microsoft.public.sqlserver.server)