Re: Connect from sql query via IP adress - is i possible?

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 08/04/04

  • Next message: cbriscoejr: "Copy job from one server to another" 
    Date: Tue, 3 Aug 2004 17:46:28 -0700

    Look at Appendix F of the Analysis Services Operations Guide
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
    It has a nice example of how you do this. 

    -- 
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Just D." <no@spam.please> wrote in message
news:xpTOc.19314$1o.15882@fed1read06...
> Thanks for the answer.
>
> "oj" <nospam_ojngo@home.com> wrote in message
> news:ui9sqkzdEHA.4048@TK2MSFTNGP12.phx.gbl...
> > You can do ad-hoc/pass through query via openrowset or opendatasource.
> > http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_78z8.asp
> >
>
http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_2be1.asp?frame=true
> > > Does anybody really know is it possible? We don't want to create a
> linked
> > > database, but we need to make some steps on the remote database,
gather
> some
> > > data and then send this data to our main server via IP connection,
> setting
> > > the connection every time when the remote server wants to transfer the
> data.
> > > Is it possible at all if we don't create a linked database or
whatever,
> just
> > > from sql script? If yes, then how?
>
> Another one idea - if I create ODBC and it's tested and works fine is it
> possible to use that for the same purpose setting a remote database name
via
> ODBC? In other words, is it possible to use a database alias that works
via
> ODBC to set a connection from sql query without a linked database?
>
> Maybe it's easier...
>
> Dmitri.
>
>
  • Next message: cbriscoejr: "Copy job from one server to another"

    Relevant Pages

    • Re: Sybase Source. What "data flow source" to use?
      ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
      (microsoft.public.sqlserver.dts)
    • Re: Sybase Source. What "data flow source" to use?
      ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
      (microsoft.public.sqlserver.dts)
    • Re: Sybase Source. What "data flow source" to use?
      ... but could still use DTS to move data. ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
      (microsoft.public.sqlserver.dts)
    • RE: Linking to an SQL Database
      ... registry entry to change the JET engine ODBC Table ... >|>| When linking to a SQL database through MS Access ... >|>| database it connects to has been upgrade to an SQL ...
      (microsoft.public.access.externaldata)
    • Re: side by side migration sql 2000 to sql 2005
      ... Unfortunately I am the wrong person to ask for help with Analysis services. ... Andrew J. Kelly SQL MVP ... I performed an inplace upgrade and my SQL Database upgrade went ... Reporting Services and then Installing Reporting Services 2005. ...
      (microsoft.public.sqlserver.setup)