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

From: oj (nospam_ojngo_at_home.com)
Date: 07/31/04 

Date: Sat, 31 Jul 2004 13:03:49 -0700

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

"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 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.
>
>

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: Updating remote MySQL databases
    ... than over Internet directly to the database. ... > I want to maintain with the WinForms program. ... > remote server, that would probably be done with PHP or whatever. ... > the appropriate dialect down the TCP/IP connection from my local PC to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: Communicating over the internet
    ... > That way you provide one manner in which to open the database, ... > can keep the connection open and then when someone wants to ... > server as the database and the soap dll connecting with a TCP socket. ... The name of the running program might help. ...
    (microsoft.public.vb.general.discussion)