Re: Connection from two servers

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/07/04 

Date: Tue, 07 Sep 2004 05:53:23 -0600

Try executing the following in Query Analyzer:
sp_serveroption 'ODED', 'data access', 'true'

-Sue

On Tue, 7 Sep 2004 12:53:24 +0200, "Oded Kovach"
<roygoldh@hotmail.com> wrote:

>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: 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: Calculated field in pass through query
    ... Using the same hardware, with a single user, Jet will be faster than MS SQL ... Server simply because Jet does not use log. ... Even within MS SQL Server, ... same query on the same data but on another MSSQL db, ...
    (microsoft.public.access.queries)
  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)