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

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?
Dmitri.You can do ad-hoc/pass through query via openrowset or opendatasource.
http://msdn.microsoft.com/library/e..._oa-oz_78z8.asp
http://msdn.microsoft.com/library/e...asp?frame=true
"Just D." <no@.spam.please> wrote in message
news:FkSOc.18891$1o.215@.fed1read06...
> 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 so
me
> 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 dat
a.
> Is it possible at all if we don't create a linked database or whatever, ju
st
> from sql script? If yes, then how?
> Dmitri.
>|||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/e..._oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/e...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
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.|||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/e..._oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/e...asp?frame=true[vbcol=seagreen]
linked[vbcol=seagreen]
some[vbcol=seagreen]
setting[vbcol=seagreen]
data.[vbcol=seagreen]
just[vbcol=seagreen]
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.|||Look at Appendix F of the Analysis Services Operations Guide
http://www.microsoft.com/technet/pr...n/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...
>
http://msdn.microsoft.com/library/e...asp?frame=true
> linked
gather[vbcol=seagreen]
> some
> setting
> data.
whatever,[vbcol=seagreen]
> just
> 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.
>